Hi,
I'm building up an application and don't know how to deal with a contract form problem.
It is a rental contract for a tool rental system.
Info frm the following tables have to be used:-
a)Client name - name, id, etc.
b)Cliente firm - firm name,address, etc
c)Machine list - machine details, serial num, etc.
d)Accessories list - accessories provided with that type of machine.
e)Various times and dates, etc.
I want to enter only the client number, then the number of each machine to be rented on to the contract form.
I think I have sorted out (a)(b) by using a set, and (e)by using calculated fields on the main form, etc.
My problem is (c) and (d):-
Each contract can have up to three machines, each machine has it's own individual number.
Each machine is classed as a type of machine, each type of machine has it's applicable accessories.
Thus (c) and (d) may be used 3 time each, but with
-If I use a look-up, the machine can get looked up, but without entering manually the machine type the applicable accessories won't be looked up. A5 does not seem to be able to use a non-manually entered field to do a lookup.
-If I use sets, I will be using the same child table three times in the same set, which I am told is not a good thing, and certainly A5 doesn't like it.
Thus, as I see it, I can't use lookups nor sets. So I am baffled for now.
I'm sure I am missing something stupid, and am certainly new to this. I think that there is a concept I am not getting.
Any help would be appreciated.
Brian
I'm building up an application and don't know how to deal with a contract form problem.
It is a rental contract for a tool rental system.
Info frm the following tables have to be used:-
a)Client name - name, id, etc.
b)Cliente firm - firm name,address, etc
c)Machine list - machine details, serial num, etc.
d)Accessories list - accessories provided with that type of machine.
e)Various times and dates, etc.
I want to enter only the client number, then the number of each machine to be rented on to the contract form.
I think I have sorted out (a)(b) by using a set, and (e)by using calculated fields on the main form, etc.
My problem is (c) and (d):-
Each contract can have up to three machines, each machine has it's own individual number.
Each machine is classed as a type of machine, each type of machine has it's applicable accessories.
Thus (c) and (d) may be used 3 time each, but with
-If I use a look-up, the machine can get looked up, but without entering manually the machine type the applicable accessories won't be looked up. A5 does not seem to be able to use a non-manually entered field to do a lookup.
-If I use sets, I will be using the same child table three times in the same set, which I am told is not a good thing, and certainly A5 doesn't like it.
Thus, as I see it, I can't use lookups nor sets. So I am baffled for now.
I'm sure I am missing something stupid, and am certainly new to this. I think that there is a concept I am not getting.
Any help would be appreciated.
Brian
Comment