Pre-set Number of Records in Table based off another Table

[SpdRacerX]

I need to have a pre-set number of records in a table or query based off another table.



For instance a patient comes into the hospital, he/she must have 4 follow-up appointments.

How can I set this up?

[jzwp11]

How can I set this up?

You wouldn't. Having a table with duplicate data violates normalization rules

You just need a query with a subquery to pull the 4 most recent record for each patient.

This site shows an example of how to do it. Look for the header:
TOP n records per group

[June7]

jzwp11, I think OP wants to pre-establish appointment records based on the patient ID. Why they don't just manually enter 4 appointment records is the question. I suspect a form/subform arrangement is needed.

SpdRacerX, are you entering data directly into tables? Recommend use forms for data entry interface.

[jzwp11]

June7, it does look like I misread the post. Thanks