>One way is to use another field with an autogenerated integer as the PK for this table and just use the Garment and >Service as FKs to their respective parent tables.
Thanks C. W.
service and garment are childs to the same parent table. it is a pricing table for drycleaning.
Example: to find price for drycleaning, which is a service, for blouse which is a garment, you would issue "SEEK str(garment.recid)+str(service.recid)" in the parent to get the price to charge the customer.
HI-YO SILVER AWAY!!
The Lone Ranger, The late Clayton Moore R.I.P.
I am a fool!