Hi all,
My scenario is this:
Clients (tblClients_ClientID) bring in their items (tblItems_ItemID)
to be sold in listings (tblListings_EbayItemNo) on Ebay.
tblClients_ClientID(P) links to tblItems_ClientID(P), and;
tblItems_ItemID(P) links to tblListings_ItemID.
The problem is this:
- When I enter client data using table format (I have not created
forms yet), I use the 'tree layout' to add multiple items for each
client, which in itself is suitable to my needs. However, I am unable
to save any of these records, because a related record is required in
tblListings.
The issue here is that items brought in by clients need to be recorded
in the database, but not necessarily listed on ebay at the same time.
I tried setting up a many-to-many transaction table tbl_ItemListings
in between (containing ItemID and EbayItemNo) but this also did not
work as a related record is still required in tbl_ItemListings.
I've reached the point where I don't know what is best to do.
Any help would be much appreciated. Thank you.
--------------------------------------------------------------
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
