Ok, when I open my Form, the ListBox displays each JobID four times because of the Color field. It's not supposed to do that. There are four colors in the tblColor that are possible, but the ones chosen for each job are stored in tblPricing. When I change the Row Source code to either tblPricing.ColorID or tblColor.Color, it still does the same thing. Anyone who can offer help to get this displaying the color name from the Color field in tblPricing will be very appreciated.
Field Is Self Repeating.. Help
- Thread starter Unified
- Start date
sfreeman@co.mer
Sam_F
- Local time
- Today, 01:09
- Joined
- Aug 2, 2004
- Messages
- 272
missing link...
You need to add a field to your jobs table called ColorID, and then link the two tables on the ColorID field and update your jobs table so that the proper color id is inserted for each job.
From the Help file:
If tables in a query aren't joined to one another, either directly or indirectly, Microsoft Access doesn't know which records are associated with which, so it displays every combination of records between the two tables. Therefore, if each table had 10 records in it, the query's results will contain 100 records (10X10). This result set of every possible combination is called a cross product or Cartesian product. These queries might take a long time to run and ultimately might produce less meaningful results
You need to add a field to your jobs table called ColorID, and then link the two tables on the ColorID field and update your jobs table so that the proper color id is inserted for each job.
From the Help file:
If tables in a query aren't joined to one another, either directly or indirectly, Microsoft Access doesn't know which records are associated with which, so it displays every combination of records between the two tables. Therefore, if each table had 10 records in it, the query's results will contain 100 records (10X10). This result set of every possible combination is called a cross product or Cartesian product. These queries might take a long time to run and ultimately might produce less meaningful results
