Jump to content

I'm sure there's a simple solution !


dstichbury

This topic is 6968 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hi there,

I'm sure there is a simple solution to this, so any thoughts would be much appreciated.

I have a database with 3 fields, Title, Language and ID

This is relating to another database, where these values would have already been defined.

Users will not know the ID, but will know the title and the language.

I have created a relationship between the databases, with Title being the key field

When someone types in the Title, I have a pop up in the language box that lists the possible languages that the particular title could be.

When someone chooses the language how do I get the unique ID that corresponds to that combination of title and language, as determined in the orginal database, to auto-enter into the ID box?

hope this makes sense!

Thanks

Link to comment
Share on other sites

Define the relationship between the user and data tables as matching both the title and language fields.

Define the ID field in the user database as data::ID. Format it as non-enterable so that the user cannot change the ID for that title/language combo.

Whenever matching title and language fields are filled, the ID field will automatically populate.

Link to comment
Share on other sites

Hi bikergeek - thanks for posting.

I'm quite new at filemaker so apologies for being a bit slow. I've created a relationship where title is the match field, and then defined language as a look-up from the title relationship (is this what you meant?)

I've then defined the ID field as data_dbname::ID,

however when i type in the language it just inserts the first ID number that exists for that title.

I'm sure i'm being very stupid - any ideas?

Thanks

Link to comment
Share on other sites

Create field Title_Laguage=Title&"_"&language in your file.

Then create the same field in original field. Create relation based on this field between your file to original. Then create lookup. Even you can do this if you use only your file by selfrelation.

Link to comment
Share on other sites

This topic is 6968 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.