Let me see if I understand your structure: tblClients: ClientID (P), .. other info
tblItems: ItemID (P), ClientID (F), .. other info tblListings: EbayItemNo (P), ItemID (F), .. other info (P = Primary Key, F = Foreign Key) Correct? The above structure assumes there can be many items for one client and many listings (perhaps in different categories?) for each item. You should be able to enter clients and items without touching listings. To enter a record in tblListings, there must be a valid ItemID, but not the other way around. John Viescas, author "Building Microsoft Access Applications" "Microsoft Office Access 2003 Inside Out" "Running Microsoft Access 2000" "SQL Queries for Mere Mortals" http://www.viescas.com/ -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of karasmith1988 Sent: Saturday, January 28, 2006 11:59 PM To: [email protected] Subject: [ms_access] Many-to-Many structure problems. 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 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/
