Jump to content
Sign in to follow this  
Jie

portal to display multiple records

Recommended Posts

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

Share this post


Link to post
Share on other sites

Okay... let's go about this a slightly different way.

You can create self-join relationships by simply setting up one in the relationship graph... but given the example, I'm a little confused as to why you're doing so.

Any clarifications that you can provide?

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
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.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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