This relationship is like a marriage - flawed!

[Sari]

I have a simple model: Bank Account Table and Interest Payments Table. I have linked them via the Bank Account ID Field.

I have a layout based upon Interest Payments Table and a popup list based on Bank Account ID. No problem. However, when I try to insert the field Bank Account Name from the appropriate table although the table is shown as being related the field name just won't appear in the field box. Consequently the data isn't there either.

What have I done wrong this time?

[Søren Dyhr]

You don't insert the bank account name, but the ID of the account - this will make the the account name visible over the relation if you wish to. The popup is a guided by the "show also" so the user shouldn't worry 'bout if it's the right ID chosen.

You better investigate the template attached:

--sd

Sari.zip

[sukisue]

This is similar to a problem I'm having... my problem is that my lists are often fairly long (ex. list of artist names) so its nice to have the name first so I can just hit the first letter of the name and jump to that section of the list. But I only want the artistID to be stored.

Any suggestions?

Thanks!

[Sari]

Hi,

I don't think I explained myself very well but I have solved the problem. I had linked the fields by the ID but wanted Bank Name to be automatically entered.

Unbeknown to me, somehow the field had a white pen colour so the field didn't actually show its contents!

Many thanks anyway.

[The Mad Jammer]

I'd like to pick up this thread for a moment. I prefer to use number fields to define relationships. By doing this I can use record numbers of subordinate tables to create relationships with parent tables.

What I'm really after is this. I have a table (TABLE2) with two fields in it, a record number and a description field. In my main table (TABLE1) I have a number field that will hold the record number of the record in TABLE I want to save.

So in TABLE1::FIELD I define the field format to be a popup that displays the TABLE2 description field (of course I have created a value list using TABLE2 description field). When I select one of the values in the popup I want to save the TABLE2 record number in the TABLE1::FIELD. This will tie the data field in TABLE1 to the selected record in TABLE2 via the record number. How can I do this? I don't want to show the record number in the POPup box, just the description.

Thanks

the Mad Jammer

[Søren Dyhr]

How can I do this? I don't want to show the record number in the POPup box, just the description.

With a calc'field containing a Case( statement, but a faster solution exists, not using the same kind of overhead a case-statement does.

1+Div((Position ( "Sunday___Monday___Tuesday__WednesdayThursday_Friday___Saturday"; thePopup ; 1; 1 )-1);9)

--sd

[SlimJim]

This is to do with the sorting. If you sort by artists name then you can start typing the name to get to that artist even though the number is showing first. (Incidentally there was a bug in the early versions of FMP7 which stopped this working, you need to be using 7.0v3) If you continue typing (moderately quickly) after the intial letter then the list is narrowed even further.

[Søren Dyhr]

Portals are more likely to make thing happen here unless you're the reincarnation of Woody Allens "Broadway Danny Rose" ...popups longer than 10-12 items becomes impractial.

--sd

[SlimJim]

I regularly use a pop-up list from a value list containing over 5000 items. The type-ahead feature enables me to get to the correct entry very quickly and also enables me to quickly find out if the new item is on the list or not.

[Søren Dyhr]

It's obviously not a networked solution, so would I instead suggest:

http://www.nightwing.com.au/FileMaker/Clairvoyance/

--sd

[SlimJim]

It's obviously not a networked solution

You are right - it isn't. I have no knowledge or experience of networked solutions so equally I am not aware that a technique which works perfectly well on a standalone breaks in a networked solution. Apologies.

[Søren Dyhr]

Well it should be different now under 7 ...but it used to be slowing as well as scroll bars in portal with lots of unstored fields.

--sd

[sukisue]

you need to be using 7.0v3

I wasn't aware of this flaw in 7.0 v1, which I am currently using. Sounds like upgrading to v3 will solve many of my issues! Thanks!

Also- Could someone elaborate on the networked solution problem? I'm not sure I understand that term. The type ahead only works in stand-alones? It should work ok when shared on a server, right?

Thanks much

[Søren Dyhr]

When filemaker works with served files from Filemaker Server or Pear to Pear, is it by an large the realeastate that needs to be updated that determins the chatter over the connections ...it used to be so with Filemaker as Debi Fuchs wrote in:

http://www.aptworks.com/downloads/presentations/PacketWatchingPres_v2.PDF

This has changed to some extend, but it's so that calculations depending on a global value which as it's implemented is stored on the workstation while the lions share of the processing of you data takes place on the server, so the work with your global value is putting a strain on the network, asking if you for some reason when using the global in a calc' have changed it recently...

Now pulling 5000 lines into a popup, causes a scrollbar makes hidden stuff beyond 11 lines availiable, not quite knowing if you can be satisfied with something in the first couple of lines. Say that one of the other users just have added a new value due to the cration of a new record, this makes a new sequence that need to be created... This means that the chunk of data passed, the last time you used the popup is unsyncronised, requirering a new updated list to be sent to your workstation - and the more data passed, the more strain is put on the network!!

Even with VNC is it the realestate that undergoes a change, that hog bandwith!!

--sd