Is the first table limited to just one record ?
In my tables I include a field:
constant_1 where Auto-Enter Data = 1
You can use this in your relationships (TABLE1::constant_1 = TABLE2::constand_1) to pull data from single-record table, as siplus suggests.
There would be no reason to have more than one record for the first table. That's what I'm trying not to do. I can create a record in the first table for the second table and enter all the data in over and over again. That is what I am trying not to do.
I don't fully understand what you just said. I get the theory, I just don't know how to apply what you said.
Create a Cartesian relationship where TableOne:.anyField x TableTwo::anyField.
Now display the desired fields from table One on a layout based on table Two – which is the same as what Daniel suggested, but using the built-in Cartesian operator ( x ), rather than having to create utility fields.
Without knowing what the whole system is about, there are reasons to have more than one record in the "defaults" table.
For example, all over the world you have a table with 2 records. It's called "toilets".
Your description of the problem you are wrestling with is way too vague for my tiny brain, but here are some possible relevant thoughts:
1. I use a process in a cashbook where I don't want users to have direct access to actual live records, where they enter data into a temporary record in a separate table with the data transferred to the live records via a script. Does that sound at all like what you are trying to do?
2. On the other hand, your description sounds like you want to create a whole lot of records (more than one, anyway) that match the data in the first single record table. Are these multiple records in the second table identical? If so, why?
3. If you have a working relationship between the two tables why do you not simple configure the fields in the second table to auto-enter via calc from the matching field in the first table?
If all of that is way of beam, can you be more explicit, even post the relationship or something meaningful? Just trying to offer something useful.