I am trying to auto populate fields in a form once I type in a unique text in my first field. I have an unbound form with a datasheet view subform for entering new invoices. I have a separate table that has cost IDs with their associated description, cost months, expense type, etc. When I enter a new invoice in the subform, I want to enter its cost ID and have the form auto populate the remaining information like cost month, expense type, description, etc and save it in that linked table. Below are the exact tables and forms I have. Any help is much appreciated. Thanks.

Cost ID Table: FINMDW-CTC Assignments
New Invoice Table: FINMDW-Workspace
Main Form: FINMDW-main
Subform linked to New Inv Table: FINMDW_S_main

I am not sure I understand what you want to do. You want to start populating a child table, and THEN have the parent table populated?

Why wouldn't you create a form, subform, and have the user select the parent record, and then just start adding invoives?

Or do you want to take data from the parent table and duplicate it in the child table (invoices?) That can be done, but not a good practice.

I am still not sure what you are doing. Can you post a use-case? Forms are not as important as tables and their relationships.

mmcdonal

Hi

I am not quite sure of your table set up however perhaps the following may help

Typically if you have a table holding Client; and Client Orders

Client holding name address phone et al
Client orders holding Units UnitCost Total Cost and so one

The client and client orders table being in a one to many relationship (Client Being the One)

Then the information required for say invoicing can be a combination of client name and adress and requisite detail from client orders such as quantity unit and total cost. This combination of information would take the form of a query

Such query would be used to create a report the output from the report being your invoice

You could almost do all of this by using the wizards (Though not entirely it would need to be tweeked such that only the invoices you required at a given point in time were actually printed

Hope this has been of help

Man Friday

Re last post

Having re-read I notice I typed table and not table(s)

Client and Client Orders should of course be separate tables

Apologies

Man Friday