D
druss74
I have a table setup such as Houses, Rooms, Itemsinroom, partsofitems. All
linked on to many. I want create a form based on the rooms table that has a
subform for the itemsinroom table, this subform would then have a
subdatasheet for the partsofitems.
I would like to put a subdatasheet on the mainform also based on the
itemsinroom table that i can use to select the record viewed in the in the
itemsinroom subform.
I can use a list box instead of a subdatasheet to select the record but
there is not enough control over the way it displays data.
Can anyone help me
linked on to many. I want create a form based on the rooms table that has a
subform for the itemsinroom table, this subform would then have a
subdatasheet for the partsofitems.
I would like to put a subdatasheet on the mainform also based on the
itemsinroom table that i can use to select the record viewed in the in the
itemsinroom subform.
I can use a list box instead of a subdatasheet to select the record but
there is not enough control over the way it displays data.
Can anyone help me