J
JGM22
Not sure how the best method would be but here is what I am trying t
do.
Table 'Paper' includes fields - vendor, paper size, paper weight, cost
Table 'Others' includes fields - level, color, b&w, staple, punch (eac
field has a number value assigned to it)
I have a form that has all of the fields on it (72 fields). When the
choose the amount of copiers per field, I want to have a lookup to bot
tables to determine the price. Simply put, there is a field calle
'level' in the table 'Others'. I want the field the user enter th
number of copies to check and see what level they have chosen on th
form and then reference that level and its assocaited prices. It the
would multiply those prices with the prices listed in table 'Paper'.
Any ideas? Thanks - JG
do.
Table 'Paper' includes fields - vendor, paper size, paper weight, cost
Table 'Others' includes fields - level, color, b&w, staple, punch (eac
field has a number value assigned to it)
I have a form that has all of the fields on it (72 fields). When the
choose the amount of copiers per field, I want to have a lookup to bot
tables to determine the price. Simply put, there is a field calle
'level' in the table 'Others'. I want the field the user enter th
number of copies to check and see what level they have chosen on th
form and then reference that level and its assocaited prices. It the
would multiply those prices with the prices listed in table 'Paper'.
Any ideas? Thanks - JG