How to show records automatically in a portal.

[nareyramos]

Hello. I have two databases; one showing clients info (name, DOB, address, phone and email) and the other with info about the books borrowed by these clients and the dates they were borrowed and returned. I want to have a portal at the bottom of the layout for each of my clients (Clients database) showing the books that each client has borrowed in the past, like a borrowing history for the Client. In addition to their personal info, this borrowing history should appear automatically in the portal in the Clients database every time I create a new record in the Books database. I don't know how to make it happen. Can somebody help? Thanks!

 

NR

[No_access]

When you say you have 2 databases I am assuming 2 tables...

I would do this with 3 tables.

1) a table with a list of all the books, title, author, isbn, etc..

2) a table called borrowed  that uses the book table as a lookup

3) a user table  with each user.

You need to create a relationship between the user table and the borrowed table using the unique_ID, you also need to allow creation of records here.

create a unique ID for each user as well as copy this ID must also be on each of the books they borrowed...  and they should appear  for you..

I know this is the 10 second rundown but if you want I will make you a file and upload with everything you need.

 

 

 

Revised, I thought Id put together a  quick file for your review.

books.zip

[FranciscoMtz]

I got something like that
 https://www.dropbox.com/s/ez7v2iatck53z4r/example-portal.fp7?m

[Lee Smith]

Please post your example files here. If you need help on this, review this instruction. Here

 

If you need further clarification about this, contact me by Private Message.

Edited August 23, 2013 by Lee Smith
changed reply

[Lee Smith]

I deleted your other post as a duplicate. Please do NOT multiple post your questions.

 

If you additional information on why we don't allow this, please contact me by Private Message.

 

Lee