Table entries out of sequence

[George Wilson]

I have a customer who is entering numeric data into a text
field through a form. There is no autonumbering field in
the table. Customer is relying on the person entering the
data to keep the correct format on the log data field. the
format is 04-0000. This has worked fine for her until
recently, when the table is viewed the newest records are
being inserted into the middle of the table and is not
appending the new data on the end of the table. Customer
has a front end/back end setup on this database. I checked
to see if any of the other fields are being sorted but
they are not. Can anyone think of a reason why these new
entries would be being inserted into the middle of the
table? Thank you for any suggestions
George

 

[Rebecca Riordan]

George,

The records in a table don't really _have_ an order. Think of the table as
a brown paper bag. You need to explicitly order by the log data field.

HTH

--
Rebecca Riordan, MVP

Designing Relational Database Systems
Microsoft SQL Server 2000 Programming Step by Step
Microsoft ADO.NET Step by Step

http://www.microsoft.com/mspress

Blessed are they who can laugh at themselves,
for they shall never cease to be amused...

 

[Frank Martin]

Hello.
I have your book "Designing Database Systems" and in figure 3.13 which shows
the use of a junction table between a many-many table I want to ask if it is
necessary for this junction table to have its own ID (eg JunctionTableID) as
well as the two ID's of the tables at either side. I have been putting one
in just in case, though it does not seem to be necessary?

Also, is it routine to make these two FK IDs a composite primary key in
the junction table if the "JunctionTableID" is present?

In chapter 14 you explain the use of relationships in constructing various
forms.
But I have not seen the type of form suitable for a 4-table relationship
where one of the tables is a Junction table explained above, that is a table
with two "many" connections from the other tables. Is there a standard form
for this?

I have found the Access2000 form-constructing wizard confusing when
constructing such a form, because when loading all the fields into it, one
hardly knows which key to use when using the form.

I have been making such forms by constructing a query first, and if I drag
down the primary keys from the "many" table and the other fields from
anywhere, then I get an updateable query which I then I convert into a form.
Is this roughly the correct method? Is there a more theoretical method to
save all the trouble, say if I have a seven-table relationship with, say,
two junction tables?

All I have found so far is if I construct an updateable query from a set of
tables then a form based on this will work.

Regards, Frank Martin