Databasic Posted March 20, 2008 Share Posted March 20, 2008 Hi -All I'm doing a horse breeding DB I have the following related tables : Investors...>Membership...>Syndicates..>Purchases...>Horses Membership and Purchase and join tables. I want a portal ( based on Horses) on an investor layout to show Horse--Syndicates---Percentage (from Membership table) In order to schieve this I put the following additional TO from horses Horses....Purchases2...>Syndicates2....Membership2 This achieved Horses( from Horses) Syndicates( from Syndicates2) - BUT if I include Membership2 for the percentage field it only gives me the first value. Can someone point me in the right direction please!! -Incidently if I have a portal based on membership on an Investor layout - I get the correct percentage for each syndicate -but I don't get the horses per syndicate.. Thanks Link to comment Share on other sites More sharing options...
David Head Posted March 20, 2008 Share Posted March 20, 2008 Just to clarify, your ERD would look like: INVESTOR ------ SYNDICATE ------ HORSE I am not sure about the last bit. If, as you say, purchase is a join table, then you are saying that a horse can be purchased many times by different syndicates. Is this the case? I would have thought that the purchase details are an attribute of the horse. Can you clarify your thoughts on the syndicate to horse relations? Link to comment Share on other sites More sharing options...
Databasic Posted March 20, 2008 Author Share Posted March 20, 2008 Thank -you David I was hopeing you might see this .. I noted on the Graph that the Purchase ...Horse relationship is showing a one to many but as you say it should be a one to one . The relationships are SydnicateTable (pk-Id) to purchase table (fk-PurID) and Purchase Table (fk-HorseID) to Horse Table ( pk_ID). I had a Pk_Purchase ID but deleted it although it didn't effect the relationships... hope that clarifies the matter and you can set me straight Cheers Link to comment Share on other sites More sharing options...
Databasic Posted March 20, 2008 Author Share Posted March 20, 2008 Sorry David its of course Syndicate Table pk_ID to Purchase Table fk_syndiD Cheers again ! Link to comment Share on other sites More sharing options...
Databasic Posted March 20, 2008 Author Share Posted March 20, 2008 Thank you David again - I took out the Purchase table and made the relationship between Syndicate and Horse a direct one to one and it works fine now - I have a lot more complicated relationships to work out - but I couldn't work out why this wasn't working out - an couldn't progress until I solved that problem.. I never did get my head around the Anchor & Bouy technique.. Cheers Bob Link to comment Share on other sites More sharing options...
By Soliant Consulting,
By Soliant Consulting,
By Soliant Consulting,
Recommended Posts