Adding a Field Updates Multiple Tables
Each Employee record contains many columns of information, so many that I have had to continue the data on a second table, with a Unique ID Field the link between the two tables. I haveformed a One-One Relationship between the tables using the ID Field.
For use by Supervisors that will be updating certain areas of data, I have created forms that look similar to our old Excel Spreadsheets. I was happy to see that adding a name to theseforms would add the name to the original table, and the same with removing a name.
Now that I have created a second table, I am hoping there is a way that adding a name to any form will add the name to two or more tables. My goal is to have the Supervisors use only theforms to input data, while of the tables that store the information remained hidden so that there are no accidental errors that corrupt the entire database.
Thank you for taking the time to report an issue.
What's wrong... Please write below.
Is LNFN the best way to link the tables?
How do you add a new name to the database that would show up in both tables or additional tables that I may add?
Creating a database; Creating tables; Changing the Field Properties in the tables; Adding Lookup Tables; Creating relationships; Adding Passwords to the database; Creating simple forms using the Form Wizard; Adding graphics and creating customized forms; Creating forms using multiple tables; Creating reports using the report wizard; Formatting reports; Creating Switchboards.
I have noticed that any edits that I make to existing records are updated in the tables.
Can anyone help. I think it may have something to do with my relationship settings, but I really am not sure
Each version of the Excel file will always contain the same # of master records with an identical update in one field.
This does not work.
We get an empty field.
How can we see the selected multiple items from the query in the field on the form(table lookup)?
John; Peter; Ted (is selected in the multiple value field)
Get these values from the tables in the database.
Then in another form:
Load these values in a new multiple value field:
See the selected items:
My problem is that this should be a multiple value field which is easy,form or anything that gives me the multiple values separated by a comma in a message box for example
Initially, I was thinking of creating a relationship between the two tables in order to pull the date from there. But this table will not always be filled out depending on the employee class.
So, I was thinking of just adding the field rather than creating a relationship as I don't always need the info in that table.
I am wondering before I go and add the extra work, would this be the most efficient way of doing this?
But now that I have upsized the tables to SQL, I can only view the data. I can't add, delete or make any changes. All my tables have a key field in them.
If I run a query on just one table, then I can make changes/updates
I am trying to load it on VB.Net and so far I managed to load CUST_TYPE and also it allows me to add/delete or update data. However, when I created another form and linked it from theCUST-TYPE form, it loads fine, but when I try to add information to the CUSTOMER table which is related to the CUST_TYPE, it does not work.
how can I add information that is related to one specific record to multiple tables.