buyer name and id

[Balen]

Hi
i have two table invoiceID and detail
invoiceID have:
ID
buyerName
date

and details have
ID
item
price
qty

i want to create other table to store all buyer names and have ID

help please

[RuralGuy]

Go ahead and create the 3rd table (Buyers) and then replace the BuyerName in the Invoice table with the BuyerID from the Buyers table and use the NotInList event of a ComboBox to add a new Buyer.

[Balen]

sorry can you tell me more about NotInlist event ??

[RuralGuy]

sorry can you tell me more about NotInlist event ??

When you want to select from a list, to eliminate typing errors use a ComboBox that presents the list to select from. You set the LimitToList property of the cbo to YES and when the user types in something that is not in the list a NotInList event is generated and you can then add it to the list if you want.