in this table Customer is actually storing CUSID (i have pleased the caption customer and made it display the name to which the CUSID corresponds to)
now in the CUSnum field i want it to automatically pic the number CUSID of which was entered into the previous field (if he customer doesnt exist it should all to add the number of unregistered customer)
i came up with the following SQL SELECT [Customer].[CUSContact] FROM Customer WHERE [Sale].[CUSID] = [Customer].[CUSID];
but for some reason it is not automatically catching the CUSID from the sale table bu asking for it to be manually inputted ! please help !