Problem with subdatasheet. Can one table have 2 relationship?

[cysklement]

Hi, I would like to ask if I could build a database where there's one table with 2 relationship and produce 2 subforms.



I have one table that can produce many subdatasheet..... I am problem building a database with it. I have breakdown my data as in.

tblmachine:
ID|serialno|type|model

tblmeterreadingmono: -//for machine that can print black and white only.
ID|serialno|date|totalreading|copier|facsimile|pri nter|A3|duplex|staple

tblmeterreadingcolour: //for colour machine.
ID|serialno|date|copiercounter:full colour| printercounter: full colour| printercounter:2colour|copiercounter:blackandwhite | printercounter:B&W|a3|duplex.

tbltoner:
ID|serialno|date|tonerno.|tonertype

tblcustomer:
ID|serialno| customerdetails........| leased/sold|

the relationship as follows:
1 machine can have many meterreading.
1 machine can have many toners
1 machine can be leased by only one clients.
1 client can leased many machine...

the problem i am facing is that when i put the tblmachine and joined to
tblmeterreadingmono and tblmeterreadingcolour. it ask for subdatasheet.......

[June7]

Don't work directly with tables for data entry/edit.

Build form with subforms.