Must show specific record from Related Table

[altair]

Hi Guys,

I have two tables related to each other. On the first layout shows records from (table1) I have a portal(table2) also. What i want to do is make a report second layout shows records from (Table1) and show a specific record from (table2).

ex. one person many licenses

Table1

--------

person1

Table2

-------

License1

License2

License3

Report-----

Name | License

------ --------

person1 | License2

I hope you can understand what i'm trying to explain.

Thanks

test.fp7.zip

Edited May 19, 2008 by Guest
added a sample file

[mr_vodka]

How would it know which specific license to use?

I would probably store the primary ID of the license in a field called deafult.

Table1

--------

pk_PersonID

fk_LicenseID_main

person

Table2

-------

pk_LicenseID

License

Then with another Table Occurrence keyed on fk_LicenseID_main <---> pk_LicenseID you would have a report of all the people with their selected "main" licenses.

[altair]

I'm having a hard time explaining it so heres a sample file hope you look at it.

I do not know if i have to make a calculation field for each date to i can put it in the report layout?

thanks again

test.fp7.zip

[mr_vodka]

Ah ok. Your report should be based off your licenses table. Reports are based off your found set, so if you find the records with the specific criteria that you are looking for then you will get what you want.

Go to layout ["report" (licenses)]

Enter Find Mode []

SEt Field [description; "PHILIPPINE"]

Perform Find []

Enter Preview Mode []

* Edit - Pending if you wanted the report for all Seaman.

Edited May 19, 2008 by Guest

[altair]

mr_vodka

thanks you very much i finally understand it.

[color:red]

SOME OF IT

Edited May 19, 2008 by Guest

[altair]

SORRY ADDITIONAL

WHAT IF I WANT 2 THINGS TO SHOW UP HOW WILL I PUT

THE FIELDS TO THE REPORT

Go to layout ["report" (licenses)]

Enter Find Mode []

SEt Field [description; "PHILIPPINE"]

[color:red]SEt Field [description; "US VISA"]

Perform Find []

Enter Preview Mode []

WRONG DATA ARE SHOWING

THANKS

test.fp7_2.zip

[mr_vodka]

Go to layout ["report" (licenses)]

Enter Find Mode []

Set Field [description; "PHILIPPINE"]

[color:blue]New Record/Request []

Set Field [description; "US VISA"]

Perform Find []

Enter Preview Mode []

[mr_vodka]

Also I suggest you take a look at this thread.

http://fmforums.com/forum/showtopic.php?tid/195401/