Ok,
I'm trying to wrap my head around building some databases that cross reference each other but I'm trying to minimize the fields as much as possible etc. Since it's hard to explain what I'm doing I'll try and create a simple example here.
Database #1 - Final Solution db lets call it an invoice of sorts
Database #2 - has thousands of items to be called upon by the invoice
On db1 we input options of
client name
client age
item name (used for final lookup to pull info from db2)
occupation
area1
area2
size1
size2
On db2 we have the following
item name (used for final lookup to export to db1)
item size
occupation restriction
area
age restriction
(and any number of other information to be pulled to db1)
Now what I want is to create a value list on db1 for "area1" and "area2" with all the names of items available to those particular areas specific to that client based on information entered.
I can pull stuff to both areas using a simple reference by creating an "area_itemsize" calculation in db2 compared to an "area1_size1" calculation in db1.
My problem is that I also need to reduce the list due to age restriction.
So if in db1 "age = 20", I want to only pull items that match "area_itemsize" where "age" is say "15...20" or maybe just ">19"
and
I also need to match it to occupation and occupation restriction
where occupation might = fire and occupation restriction is a field that uses a value list and check boxes and can say "fire, water, dig and/or all" and I want "fire" to match to "fire" AND "all".
So I've been buiding multiple databases and trying things and I can't seem to wrap my head around how to get it to pull the information based on so many criteria that could be different for each "client
I'm trying to wrap my head around building some databases that cross reference each other but I'm trying to minimize the fields as much as possible etc. Since it's hard to explain what I'm doing I'll try and create a simple example here.
Database #1 - Final Solution db lets call it an invoice of sorts
Database #2 - has thousands of items to be called upon by the invoice
On db1 we input options of
client name
client age
item name (used for final lookup to pull info from db2)
occupation
area1
area2
size1
size2
On db2 we have the following
item name (used for final lookup to export to db1)
item size
occupation restriction
area
age restriction
(and any number of other information to be pulled to db1)
Now what I want is to create a value list on db1 for "area1" and "area2" with all the names of items available to those particular areas specific to that client based on information entered.
I can pull stuff to both areas using a simple reference by creating an "area_itemsize" calculation in db2 compared to an "area1_size1" calculation in db1.
My problem is that I also need to reduce the list due to age restriction.
So if in db1 "age = 20", I want to only pull items that match "area_itemsize" where "age" is say "15...20" or maybe just ">19"
and
I also need to match it to occupation and occupation restriction
where occupation might = fire and occupation restriction is a field that uses a value list and check boxes and can say "fire, water, dig and/or all" and I want "fire" to match to "fire" AND "all".
So I've been buiding multiple databases and trying things and I can't seem to wrap my head around how to get it to pull the information based on so many criteria that could be different for each "client
