Same field in multiple tables

[chantale]

I'm using Access 2003 and I would like to know how can I use a field from one table and incorporate it into another? I only want to be able to update this field in one table so the info will be current in another table.

 

[Pat Hartman]

There is no automatic facility for this since it violates second normal form. If the tables are related, you can always use a query as the RecordSource for a form or report and that will allow you to select columns from both tables. For example, if you want to see the Customer's name and address on an Invoice, simply join the Order table to the Customer table.

 

[chantale]

Suggestions on database

Thanks for your help. If you would like to check out and give some suggestions as to the database I'm working on, feel free to email me and I can send it to you.

There is no automatic facility for this since it violates second normal form. If the tables are related, you can always use a query as the RecordSource for a form or report and that will allow you to select columns from both tables. For example, if you want to see the Customer's name and address on an Invoice, simply join the Order table to the Customer table.