S
SirPoonga
This is going to take some explaining. I'm going to use a generic
example of the problem at hand.
Lets say I have a products table. For each product it has a make and
model along with other attributes. We assign each product our own
prduct code. The product can have two options, lets call them option1
and option1. I have a table to store info for option1. There is an
autonumber ID field, product code field to link to the products table,
and other various fields for attributes of the option. Simular goes
for option2.
Now, a specific manufacturer has their own codes for their product.
Given a single manufacturer's code one would know the make, model,
option1, and option2. So in the relationships this table is tied to
the products, option1, and option2 table. I can look up our products
based on the manufacturer code easily enough.
However I have a form witha s ubform in it. It's a custom filter form
to find our products. It consists of a series of dropdown boxes then
an "Apply Filter" button. The button updated the subform's .Filter and
..OrderBy. However, I'd like the manufacturer's part number to show up
if there is one. Since ther table that contains that info is tied to
several tables I cna't use a left join.
I thought about making a table that stored the product table primary
key, the option1 table primary key, the option2 primary key, and the
manufacturer code table primary key. But I run into the same problem
that that table is tied to everything therefore I can not do a left
join.
By left join I mean, how does access put it, ALL records from the
products table, options 1 table, options 2 table and only those from
the manufacturer code table that match.
Any ideas on how to do this?
example of the problem at hand.
Lets say I have a products table. For each product it has a make and
model along with other attributes. We assign each product our own
prduct code. The product can have two options, lets call them option1
and option1. I have a table to store info for option1. There is an
autonumber ID field, product code field to link to the products table,
and other various fields for attributes of the option. Simular goes
for option2.
Now, a specific manufacturer has their own codes for their product.
Given a single manufacturer's code one would know the make, model,
option1, and option2. So in the relationships this table is tied to
the products, option1, and option2 table. I can look up our products
based on the manufacturer code easily enough.
However I have a form witha s ubform in it. It's a custom filter form
to find our products. It consists of a series of dropdown boxes then
an "Apply Filter" button. The button updated the subform's .Filter and
..OrderBy. However, I'd like the manufacturer's part number to show up
if there is one. Since ther table that contains that info is tied to
several tables I cna't use a left join.
I thought about making a table that stored the product table primary
key, the option1 table primary key, the option2 primary key, and the
manufacturer code table primary key. But I run into the same problem
that that table is tied to everything therefore I can not do a left
join.
By left join I mean, how does access put it, ALL records from the
products table, options 1 table, options 2 table and only those from
the manufacturer code table that match.
Any ideas on how to do this?