I've created a rather simple database, with the intention of sending it out to clients as a report layout for them to fill in each week.

I require 3 tables on this one database page. Each of these tables needs 2 or 3 simple columns and new records can be created depending on how much info needs to be entered.

I've discovered that the only way to create "records within records" so to speak is to use a portal. I've created very simple portals (and checked and checked that I'm doing it write in various manuals) and have allowed the creation of new records in both the master and related layouts.

The information at first pulls through fine, but then when I try and create a second record (or what looks like a row in that table) - it repeats the information that is in the first. It will not allow me to type any other information in the next record.

Has anyone any idea what I'm doing wrong?

Many thanks, Sarah

What does you relationship look like?

The relationships are defined as equal to, but I'm not sure if that's the question you're asking?

The only reason I need them to relate to another layout is in order to create new records on the master layout - the report layout.

If that makes sense?

No I mean what are the table occurrences and key fields that are in question?

For example...

Person Table

pkPersonID

PersonLastName

PersonFirstName

Phone Table

pkPhoneID

fkPersonID

PhoneNumber

PhoneNumberType

You would be on a layout for Person with a portal display records for a table occurrence of Phone. The relationship would be keyed on pkPersonID to fkPersonID

Also, allow creation of records should really only be turned on here for the child rrecords, not the parent.