Single entry

  • Thread starter Thread starter Thomas Baughman
  • Start date Start date
T

Thomas Baughman

I want to make a single entry of a customer ID that will generate that same
ID in another table once a choice has be made; Eg. CustomerID in
tblCustomers AND CustomerID in tblCategory.

Anyway help would be greatly appreciated.

Thanks!
 
I want to make a single entry of a customer ID that will generate that same
ID in another table once a choice has be made; Eg. CustomerID in
tblCustomers AND CustomerID in tblCategory.

Anyway help would be greatly appreciated.

Thanks!
Click to expand...

Generally you do NOT want to do this. Creating empty "placeholder"
records is usually neither necessary nor desireable!

Typically instead, you would use a Form based on the "one" side table,
and a Subform based on the "many", using CompanyID as the master/child
link field. When you create a record on the subform (but not before),
the ID will be automatically filled in.
 
Pretty sure we've answered this before for you. Again, you need to build
your tables with the proper keys and relate them. Once that is done, a new
customer entry will allow related entries of customer orders, etc.
-Ed


example:
tblCustomer
customerID - primary key
customerLastname - indexed (dupes OK)
etc.

tblProduct
productID - primary key
productDescription
etc.

tblOrders
orderID - primary key
customerID - foreign key (related many-1 to tblCustomer)
productID - foreign key (related many-1 to tblProduct)
orderdate - indexed
etc.

-Ed
 
Back
Top