Jump to content

portal to display multiple records


Jie

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

Recommended Posts

  • Newbies

I have used filemarker 3 years ago, but could not remember how I created a portal fields. Fo example, i have a table only with two fields "name", and "hobboy". How to define a self-join relationship so that i can enter multiple recrods into the "hobby" field?? I am depressed that the Filemaker Pro 9 does NOT give a good example on this issue..

Thanks!!

Jie

Link to comment
Share on other sites

  • Newbies

Hi, I just want to create a field that can hold multiple rows. For example, if I create a table with two fields "PatientID" and "Visits". For each patientID, there are multiple visits. I want to create a form where multiple visits can be entered. I really hope that this simple scenario explains my needs well.

Link to comment
Share on other sites

Yup... but the relational theory behind that is a little more complex. What you're talking about is a classic one to many relationship (at least it's not a many-to-many).

What you have is something like this:

Patients

- id

- first name

- last name

Visits

- id

- date

- doctor seen

- patient_id

What you'll have is a record for a patient:

1002

John

Doe

and a record for his visit:

3953

2/22/2007

1336 (external key for a doctor)

1002 (the patient's id)

You'd link it on the relationship graph and whatnot in a very basic manner. Problem is, I don't have the space here to explain much relational theory sooooo, I'll kick you over to this book. It's really the best primer on any of this stuff and will give you the foundation that you need to build solutions like what you're talking about.

Link to comment
Share on other sites

This topic is 6120 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.