Field refresh in query with one-to-one matching

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Greetings,

I have posed this question in another thread, but I want to explain further.
For the sake of managability, I have split a file with a large number of
fields into two. One contains basic information regarding an entity, the
other contains specific information, in this case the entity's weekly lunch
program. The problem is that when the index fields for both files are unique
keys, the data does not refresh when the index key is entered into the query.

I plan to utilize this query in a form, to allow for data entry of ONLY the
weekly lunch program. The basic information will be uploaded from an Excel
spreadsheet. Is there a wa to make the fields properly refresh when the key
is entered or selected from a pull down?

If I make the key on the second file non-unique, it works, but then I can
end up with duplicate lunch programs for each entity.

Thanks in advace for you support,

DKB
 
What's your definition of file. Namely the one that was split.

Out of curiosity, why isn't the Weekly Lunch data for the Entity a child
table?

tblEntitiy
EntityID
EntityName

tblEntityLunch
EntityLunchID
EntityID
WeekStartDate
ServedNo

etc.
 
Back
Top