Carry data over to another form and table

L

langirl77

Hi,

I have a table that contains server information, name, hardware specs etc.
I want to add the ability to keep track of partition size. There is to much
to keep it on the main form, so I've created anoter form to enter this data.
I've got it so the name carries over to the next screen. I can't get it to
save properly. If I use the same table that the other information is on for
this data to go to, it creates a new record with just the partition sizes.
If I create a new table just for partition sizes it won't carry the server
name and save it in the table so then when I pull up a server it doesn't have
anything associated with it. How can I make this work?

Thanks.
 
J

John Vinson

Hi,

I have a table that contains server information, name, hardware specs etc.
I want to add the ability to keep track of partition size. There is to much
to keep it on the main form, so I've created anoter form to enter this data.
I've got it so the name carries over to the next screen. I can't get it to
save properly. If I use the same table that the other information is on for
this data to go to, it creates a new record with just the partition sizes.
If I create a new table just for partition sizes it won't carry the server
name and save it in the table so then when I pull up a server it doesn't have
anything associated with it. How can I make this work?

Thanks.
Click to expand...

By not using a separate form. Keeping the two forms in synch, without
causing data collisions ("another user has this record open for
editing") is a major hassle!

Simply put a Tab Control on your form; put one set of controls on the
first page, and the partition info on the second page.

Better yet - normalize your *table structure* so you don't have more
fields than can fit on a screen! I don't know if this is a real
problem here, but it sure sounds like it!

John W. Vinson[MVP]
 
L

langirl77

Yes, there probably is to much in the main table, but I just inherited it and
am trying to work with it. Is there no way to have it save the data carried
over from another form into the new table?
 
J

John Vinson

Yes, there probably is to much in the main table, but I just inherited it and
am trying to work with it. Is there no way to have it save the data carried
over from another form into the new table?
Click to expand...

Now wait a minute.

Your question had to do with the display of data on forms.

Now you're talking about trying to store data redundantly in tables
(NEVER a good idea).

Of course, it's *possible* to do the job wrong, by running Append
queries or Update queries to store the same data in two tables. It's a
sure-fire recipe for trouble, it's a bad idea - but it is in fact
possible.

I'm leaving for a week's vacation tomorrow, so you might want to
repost in a new thread; it would help if you explained the
(redundant?) data tables, indicate what information you need carried
from one table to another table, and just how you would like your form
to work. I'll try to check this thread tomorrow but after that... see
if one of the other volunteers here can help.

John W. Vinson[MVP]
 
Top