1) Novice
2) Creating a database where I have one table that has all companies; including customer and supplier- sometimes both.
I have created two queries, one for customers and one for suppliers.
3) I cannot get the Lookup and Relationship Wizard to recognize queries as a source for a field in a table (Purchases).
4) I then created a form from the table (Purchases) and used the property 'row source' to select the appropriate query.
That worked in that it gave me the appropriate query table of companies to pick from.
But the table will not store the selection.
2012 Partner Database.zip
What am i missing?
thanks!