ann_bas

Hi John, Thank you so much for sending me this file. I greatly appreciate your help. I have one more question. Is there a way of showing the data from both the tables on the same layout, meaning can I have column 1 with fields displaying 2000 data from table 1 and separate column 2 with separate fields displaying 3000 data from table 2, on the same layout showing the total records of 5000 (table 1 + table 2)? Thanks Ann

Hi John, I would like to try option2. Contact info from one table is already there on a layout but i can't make the contact info from the second table appear on a portal on the same layout. My layout is accepting only the first table. What should I do to solve this?

Thanks Lee. It worked!

Hi John, I tried this and I got 0 value in both first and last name fields.

Hi, I have a field where I have first name and last combined but a comma in between them like Smith,John. I have over 70,000 names. So I can't manually separate these first name & last name. Is there a way I can separate these first name & last name? Any help would be greatly appreciated!

Importing the info from one table into another makes a lot sense and i can do that very easily. But in my case i want both these tables on a single fm database. My question is how can I make a layout that now already shows 2000 contact info(first name, second name & address) from contact table also show 70,000 contact info from dre table?

Thank you for your quick response Ted. I already have 2000 contact info in contact table. I need to add 70,000 plus contact info from dre table onto contact table. Both these tables have same field names like first name, last name, street address, city and zip. I have Contact ID as primary key in contact table & foreign key in dre table and dre ID as primary key in dre table & foreign key in contact table. I have a layout which shows contact info from contact table. What I have to do now is add the contact info from dre table onto the same layout. I hope this makes sense. Please suggest what would be best solution. Thanks

Hi, I am new to filemaker. I have a problem that i need to solve immediately. I have two tables, contact table and dre taable. I have contact ID as a primary key in contact table and contact ID as a foreign key in dre table. Where in dre table I have dre ID as a primary key and I have set this a foreign key in contact table. Both of these tables have same fields like first name, second name, street address, city and zip. My target here is to merge all the data that I have inside first name, second name, street address, city and zip from dre table with that in contact table. Any help from you would be a life saver!