Calculated Field

[plastikman808]

Hi,

I have 2 tables, 1 called [Products] that lists all the products that are available for sale with the Primary key as the ProductCode. The 2nd table is [SalesReceipt]. A field in the [SalesReceipt] is the Product name from the [Products] table.

Can i use the calculated field to do some sort of SELECT query that will pull this data in automatically once the user has put in the product code?




I tried this, but the Syntax is wrong...do i need to do an Append query of some sort?







Thanks in advance for any help

[plastikman808]

ignore the bottom screen shot

[June7]

No, cannot use calculated field like that. Calculated field is for simple calculations of other fields, like: [Quantity] * [Price]

Can each sale have multiple products? If yes, you need a related child table, SaleDetails, to store a record for each product associated with that sale. Use form/subform arrangement for data entry.