a quick question...

I know I'm doing something wrong because I'm gettin the error message "The expression is typed incorrectly, or is too complex to be evaluated...".

Basically, its an example of a stock control system and the guide I'm using says to construct the appropriate database tables and link them. The finished relationships should look like this

Stock
ItemID
Quantity
Description



(one to many)



OrderLines
OrderNo
ItemID
Quantity



(one to many)



Orders
OrderNo
Date
posted



What I need to know concerns each primary key (in bold here). I need to know what format each is, Autonumber or text.

Its probably very simple but Ive tried and failed too many times!

Thanks,
James

Are the primary keys generated numbers or are they actual numbers that may be input and don't have to be entered in sequence (which is what Autonumber would do)?

If it is the latter why not define them as a number?

If they are alphanumeric, however, you would have to define them as text (non-numeric).

Hope that helped some.

B