Auto-populate and Attachment Problem
Thank you for taking the time to report an issue.
What's wrong... Please write below.
I then realized that with that setting users can enter duplicate data. When I changed Indexed to Yes(No Duplicates) I lost the auto populate function.
I would like to have the best of both worlds. I need the field to stay Unique as well as populate those 3 fields.
I have an employee table that shows employees and some basic information about each of them. This table has an employee ID field that is not an autonumber but it is unique to each employee (10004928).
I have other tables that also use that same field and I want the first and last names to auto populate based on the main employee table. These other tables are tracking OT and Vacation time used.
How do I make the later tables auto populate the name fields when you key the employee ID?
This would be similar to how Office or Word does an auto type based upon the initial letters typed.
I've searched the forums and found a number of inquiries regarding auto population, but they're usually tied to another field or table, not the same field in the same database
There are three tabs on the form, each is populated by the user with data for the record, and each of these tabs is putting data into a specific table (one for each tab). Not sure if it is relevant but the value going into the fields inquestion are the primary key fields for two of the three tables.
When one of these fields is populated on the form, the other two automatically populate with this value.
However, this is the only way they can be populated, the number has to go into the textbox for field 3, and field 1 and 2 populates. I can't enter into field 1 or2.
This is how we would like it to work, but I want to populate one of the other fields first (field 1), and the remaining two auto populate.
The problem is, no one here as an access expert and no one nor I can understand how these fields are linked? Everyone is scratching their heads at it.
My problem: I recently gathered some data in the attachment fields in the development copy of the database and wanted to transfer the additions to the production table. The update query came back with a message to the effect that you can't use an attachment field in an update query.
Has anyone else encountered this problem? If so, what is the workaround? VB or manual re-entry of the data