I have a database that contains a "Cutomer" table. This table contains several columns. Two of which,are "RCustomerID" & "CustomerName". I use these columns repeatedly through out several tables. My problem is this...When I enter a record into one of my tables, the "RCustomerID" defaults, but the name does not. In the "Customer" table, it does. I would like to have the id & name default at the same time. If it helps...the "Customer" table contains both of these fields and can be use as the parent table to access information from. I hope this makes sense. HELP!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How do I default information from one table to another?
- Thread starter rlh777
- Start date
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question
