CUSTOMER NAME TABLE:
CUST NAME CUST NO
ZOLOTY ELECTRIC 205506
ZOLOTY ELECTRIC 108345
ZOLOTY ELECTRIC 58979
When the user types the Name… ZOL.. then have “ZOLOTY ELECTRIC” will finish filling in the field, while at the same time “CUST NO” field has all three (3) numbers appear, waiting for the user to make a selection.
I have the CUST NAME set to a Lookup Table, (35,000) records. This part is working OK.
What I NEED is the part where the CUST NO somehow connects to the CUST NAME field and then List the different CUST NO's so that the user can SELECT the appropriate CUST NO for this record.
Thanks for any direction you can help me with.
Barney Henley