To use same column in 2 tables

[pl1]

Hi everyone,
I'm using MS-Access 2003, OS: Window XP Professional sp3.

In Northwind database (sample Database),the Suppliers table have column "SupplierID" which is also present in Products table, my question is how can I use same column in 2 tables without entering data in them manually

Also the relationship between 'Suppliers' table and 'Products' table is one-to-many. The column type in Products table for column "SuppliersID" is number but still a combobox for the list of suppliers names is displayed ??
How can I do the same in my table(s) ??

[nico5038]

Hi everyone,
I'm using MS-Access 2003, OS: Window XP Professional sp3.

In Northwind database (sample Database),the Suppliers table have column "SupplierID" which is also present in Products table, my question is how can I use same column in 2 tables without entering data in them manually

Also the relationship between 'Suppliers' table and 'Products' table is one-to-many. The column type in Products table for column "SuppliersID" is number but still a combobox for the list of suppliers names is displayed ??
How can I do the same in my table(s) ??

Just create a Main form based on the Supplier and add the Products as a subform. The wizard will propose a linking field. Accept that and see that Access will sync the rows in the subform and add the ID automatically when inserting a new row.

Nic;o)