Updating Tables

[Tim Wallace]

Hello everyone,

I have a question that I am not sure of how I would go about it. (It
could be that I am a bit of an idiot).

What I want to do is enter data into a form that updates a table.

Basically I am creating a way of managing equipment.

So I have user name and department as 2 of my columns, and if I enter
the data straight into them not a problem, I can create a search of
them and that works fine. I have another table that uses these 2 as a
list, so that I can select them from a list of people, all good.

Now this is where my problem starts, when I add data to the main form,
the data I add in does not update the other tables. If I look at main
sheet it has all the data in it, but the other tables do not show any
of the addons.

My end result is that I want to create a form that I can add my data
to, change data, and if I add a new records (piece of equipment) it
will go back to the (User Name, Department, etc) tables.

If anyone can offer some help that would be great.

Thanks

Tim Wallace

 

[Ted Allen]

Hi Tim,

What is the record source for your form (under form
properties, on the data tab)? It sounds from your post
like it should be your table listing the people - if you
are trying to enter new people and select appropriate
departments (or you could also use a query linking the
two tables).

If the record source is correct, check the control source
for your controls, they should be set to the fields that
you want to update in the table.

Post back with more info if this doesn't help solve your
problem.

-Ted Allen

 

[Tim Wallace]

Thanks for the reply,

the only problem with linking the two tables is that each table only
has one thing in it, ie User Names, Serial Numbers or whatever.

So this means that I am unable to link them as they have nothing in
common.

 

[John Vinson]

Thanks for the reply,

the only problem with linking the two tables is that each table only
has one thing in it, ie User Names, Serial Numbers or whatever.

So this means that I am unable to link them as they have nothing in
common.

Ok.

Suppose you had two buckets full of slips of paper, one with a bunch
of user names; and the other bucket full of serial numbers.

What would you be able to do to manually link them?

If in fact you have no fields in common, and no way to associate a
particular user name with a particular serial number, IT IS ABSOLUTELY
IMPOSSIBLE to update them.

 

[Ted Allen]

Hi Tim,

As John mentioned, you really must have a relationship
between the tables to be able to update the data. You
mentioned that one of your tables uses the other as a
list source. I would expect this to mean that you are
filling in a field in one table using the other as a
lookup. If so, that is your relationship. If not, you
have to either add fields to one or more of your tables
to be able to relate them to one another, or create an
entirely new table to serve solely as a join between the
others.

It's hard to give any specifics with the info that you
have posted, but if you post your current table/field
structures and what you would like to do with them, I can
post back with suggestions.

HTH, Ted Allen