relationship and find issues

[Tina Camilleri- Middleton]

I am working with the tutorials and I have created 4 tables which i have linked with primary and foreign keys.

We have a business that works with companies that manage multiple buildings. so each one client will have 100's of buildings I need to link.

I have done this with a one-many relationship using a primary key for the company table and a foreign key in the building site table.

I am creating a layout that displays both tables which i can get working to a certain degree...the main problem i have is I can only retrieve one record...i have gone into find mode typed in some details of other records i have entered but it still only retrieve the same record over and over again....

is there anyone that can tell me what i have done wrong?

i am getting very frustrated i know it can be done as i used to work with a file maker database before and it could do it....i just dont know how to make it do it..

any help, advise would be appreciated.

Tina

[efen]

This question is a repeat of that on

http://fmforums.com/forum/topic/81950-relationship-questions/page__fromsearch__1

[Tina Camilleri- Middleton]

yes i am sorry I was not sure where to post I am new to the forum environment....I am sorry if i have done the wrong thing..i just need some help..

[bcooney]

Your description leaves out some info. You mention 4 tables, and yet only describe Companies and Buildings. What are the other two tables? Is it pertinent?

When you enter Find mode, what layout are you on and what's on that layout? That is, are you on a Company layout that has a portal of related Building records? What are you trying to Find?

[Lee Smith]

Hi Tina, and welcome to the Forum,

I was not sure where to post

no problem, sometimes it can be confusing in that regard. I deleted the other post.

[Tina Camilleri- Middleton]

ok I am sorry it appears being a newbie to this confuses not only myself but any one trying to help....ok lets see if i can explain what I have done and what I want to do more clearly....yes i did have 4 tables however i now have 3..

one table holds the information of our clients...for which i have a primary key...second table holds the informations pertaining to buildings managed by the clients in table 1 also has a primary key and a foriegn key for parent table.....3rd table holds information pertaining to the jobs we are doing at the building sites..

Now I have firstly created a layout to which add the client details...what my husband want me to be able to do is on this same layout (client details) retrieve the buildings not as a list of many but one record at a time. however when i did this....(and I have probably done this wrong) it would display one record however when i went into find mode (one this same layout) it would only retrieve the same record even though I had entered many different records and I am trying to find the buildings not the client but we are using the client layout...

I am hoping that makes it a bit clearer... if not I am happy to send a file for someone to look at if that is easier...I am just very new at this and its hard sometimes to find the answer yourself when you dont know what to look for....

anyhelp is appreciated thank you in advance for your time.

Tina :laugh2:

[LaRetta]

Hi Tina, not to worry ... there is a nice group of people here and we understand that being new means that questions can be difficult to formulate.

when i went into find mode (one this same layout) it would only retrieve the same record even though I had entered many different records and I am trying to find the buildings not the client but we are using the client layout...

To view multiple Buildings records on a Client layout, you need to use a portal or switch to a layout based upon the Buildings table occurrence. Since you and your husband want to stay on Clients, add a portal to your Clients layout by dropping into layout mode ( View > Layout Mode ) and then Insert > Portal and select your Buildings portal.

It is likely that your find was producing the correct (multiple) buildings but since you were on Clients layout (and you had only a field from Buildings on your layout), you could only view one (the first) related Buildings record. Using portals allows you see into the 'many' side of relationships without going there. Ask away if things aren't clear.

[comment]

See if this helps:

http://fmforums.com/forum/topic/73552-isolating-records-witin-portals/page__p__348086#entry348086

[Ron Cates]

If you would like to see a found set of the Building records and be able to view them one at a time you will want to be doing the find on a Form layout based on the Buildings table.

Edit:

Ooops. Too slow :)

[LaRetta]

Wanting only one Building at a time is possible also. I have attached a demo how you can use global field and conditional value list to handle it. Look specifically at how the value list is set up (this restricts buildings in the pop-up to those belonging to the Client you are currently viewing). Also note that the fields are from the new table occurrence of Buildings (check in the graph) ... your primary relationships are colored. The auxiliary relationship remains grey.

You can also put a portal of a Client's Buildings on the layout and attach button to it which sets the global field (thus completing the auxiliary relationship for your selection mechanism).

ADDED: You haven't indicated your FM version or OS. It would help to update your profile with this information. You could also just filter a one-row portal using the same global field (no relationship required). The portal filter would be: gSelectBuilding = Buildings::BuildingID.

ADDED AGAIN: I changed the demo to also show how you can use a one-row portal if using vs. 11.

Buildings.zip

Edited February 3, 2012 by LaRetta

[LaRetta]

Well Michael and Ron's posts weren't there when I posted. Very strange. Anyway ...

[Ron Cates]

You beat Comment by 1 minute and me by 4 mins. I guess when I start a response I shouldn't allow myself to get distracted. SQUIRREL!!