Populating two fields from the same lookup table?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Using the lookup wizard, I'm trying to make two fields (in tblGames), named
"Visiting" and "Home", both lookup their values from a table called
"tblTeams". I'm getting a "could not be saved" error when I try to do this
for the second field. The first one works ok. What's the problem here?

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using table field in Lookup Wizard 3
Access - Database - Form - Field Validation - LookUp function 3
Thoughts on Lookup Fields 7
Populate field from data in another table 7
Concatenate two fields and then make a lookup box 2
Lookup Yielding Key Field Values Instead of Desired Field Values 5
Multicolumn lookup in one table from another. 7
lookup table based on two criteria 3

Back
Top