I�m trying to make a application, and one of the basics is the ability to display several different records frm one db simultaneously in a set called by the parent of the set.
The situation is of one person renting more than one item from a products list.
We use it for:- cost list for rental on invoice for different line items, different drivers/employees for the same company, the same part used for repair of different machines, etc.
eg, one person renting several library books.
I have tried following this (very helpful) message board advice, but I am still stuck.
I have now:-
a person list db.
-linked to: one to many, person number field to linking field.
a linking db, two fields. linking field, and machine number field.
The machine number field of the linking db, has field table lookup to the the db of the machine db.
In that configaration nothing much works, just a browse of the linking field; with it�s two fields.
If I have a further link in the set, one to one from the linking db machine number to the machine db, machine number field it works.
I get the machine details I want from the lookup field. BUT, only for the last record; not for the several I need. If I try one-to-many, nothing.
I am sure I am missing something simple, but not getting it.
Attachments don�t seem to work here I can�t get to print or read them, and I certainly consider myself a newbee at all computor stuff.
This is a continuation of my question;- Sets, using child db twice in form does�nt work dtd approx 1/12/2001
Brian
The situation is of one person renting more than one item from a products list.
We use it for:- cost list for rental on invoice for different line items, different drivers/employees for the same company, the same part used for repair of different machines, etc.
eg, one person renting several library books.
I have tried following this (very helpful) message board advice, but I am still stuck.
I have now:-
a person list db.
-linked to: one to many, person number field to linking field.
a linking db, two fields. linking field, and machine number field.
The machine number field of the linking db, has field table lookup to the the db of the machine db.
In that configaration nothing much works, just a browse of the linking field; with it�s two fields.
If I have a further link in the set, one to one from the linking db machine number to the machine db, machine number field it works.
I get the machine details I want from the lookup field. BUT, only for the last record; not for the several I need. If I try one-to-many, nothing.
I am sure I am missing something simple, but not getting it.
Attachments don�t seem to work here I can�t get to print or read them, and I certainly consider myself a newbee at all computor stuff.
This is a continuation of my question;- Sets, using child db twice in form does�nt work dtd approx 1/12/2001
Brian
Comment