daverskully
Registered User.
- Local time
- Today, 05:42
- Joined
- Mar 10, 2008
- Messages
- 23
I am looking to populate fields of one form based on another table with about 100 records.
Information
Table Name: 1) StaticInfo
2) Data
Form Name: EntryForm (Based on the Data table)
I want to be able to select a value in a combo box in the EntryForm and have certain fields populated in that form based on the StaticInfo table.
Want to use all of the fields in StaticInfo to populate the same fields in Data. Historical data in the Data table needs to remain intact, meaning that if something is changed in the StaticInfo table, the historical records will remain unchanged in the Data table.
So, if I am able to select a department in a combo box in the EntryForm and have the fields populated in this form based on the StaticInfo table, will the records in the Data table change or not change if there are changes made to the fields in the StaticInfo table?
I have the information in StaticInfo, which I want to be automatically entered in the form EntryForm, so that it can be saved in the Data table along with the other information that will be entered in the form. The Data table (and Entryform) contain 6 memo boxes in which data must be entered. I want to have it so that the automatically populated information comes up when someone selects a department from a combo box, then once that information is in the fields, the individual can proceed to enter their corresponding information into the 6 memo boxes available. Once this is done the individual can hit a save button and all of the information would be a new record in the table Data. Could someone provide a method as to how I would go about doing this?
Thank you in advance
Information
Table Name: 1) StaticInfo
2) Data
Form Name: EntryForm (Based on the Data table)
I want to be able to select a value in a combo box in the EntryForm and have certain fields populated in that form based on the StaticInfo table.
Want to use all of the fields in StaticInfo to populate the same fields in Data. Historical data in the Data table needs to remain intact, meaning that if something is changed in the StaticInfo table, the historical records will remain unchanged in the Data table.
So, if I am able to select a department in a combo box in the EntryForm and have the fields populated in this form based on the StaticInfo table, will the records in the Data table change or not change if there are changes made to the fields in the StaticInfo table?
I have the information in StaticInfo, which I want to be automatically entered in the form EntryForm, so that it can be saved in the Data table along with the other information that will be entered in the form. The Data table (and Entryform) contain 6 memo boxes in which data must be entered. I want to have it so that the automatically populated information comes up when someone selects a department from a combo box, then once that information is in the fields, the individual can proceed to enter their corresponding information into the 6 memo boxes available. Once this is done the individual can hit a save button and all of the information would be a new record in the table Data. Could someone provide a method as to how I would go about doing this?
Thank you in advance
