Linking form information to specific tables

[trenttdogg]

Hello,
I am having a hard time getting my form(s) to link to the correct tables.
What I am trying to do is this:
I have tables set up for my "members". I want to create a form that will put
the information entered on the form into the correct table. EX: I have
members A, B, C and D. One of them refers member X. I want to create a form
where I enter member X's information and it not only creates a new table for
member X but puts his information in the correct "referring" members table.
ie, the form would have a "referred by" field and I would enter member A. I
want the form to automatically put the new members info into member A's table.
If I haven't confused you too much, please let me know how this can be done.
Thanks,

 

[Jeff Boyce]

I may be too literal in my interpretation of your description ...

You mention "creating a new table for member X" and putting information into
the "correct referring member's table".

If you mean that you have one table per member, you have committed
spreadsheet on Access. Access is a relational database, and expects
well-normalized data, not 'sheet data. If you are (literally) using one
table per member, stop now!

Since we aren't there, how 'bout if you describe a bit more how your
tables/data are set up. If it turns out that they're more like spreadsheets
than relational tables, you'll need to decide. If you don't normalize your
data, you (and Access) will have to work overtime to come up with
work-arounds.

If you don't understand "relational" or "normalization", it's a bit of a
learning curve ... but you will either pay now or pay later!

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[trenttdogg via AccessMonster.com]

You are exactly correct, I am into spreadsheet thinking. I take it that is
where I am going wrong? I am trying to create a database where I enter the
information on a form and it creates a "record" in 2 seperate databases( 1-
member database, 2-referring member database). Basically, I will have
"regular" members and "vip" members. The vip members will get credit for the
members they refer. So I would like to have one form that I input a new
members info into and it will create a record in the "regular" members
database and also put the in the correct referring (vip member) database. I
don't know if I'm making sense. Am I?

I may be too literal in my interpretation of your description ...

You mention "creating a new table for member X" and putting information into
the "correct referring member's table".

If you mean that you have one table per member, you have committed
spreadsheet on Access. Access is a relational database, and expects
well-normalized data, not 'sheet data. If you are (literally) using one
table per member, stop now!

Since we aren't there, how 'bout if you describe a bit more how your
tables/data are set up. If it turns out that they're more like spreadsheets
than relational tables, you'll need to decide. If you don't normalize your
data, you (and Access) will have to work overtime to come up with
work-arounds.

If you don't understand "relational" or "normalization", it's a bit of a
learning curve ... but you will either pay now or pay later!

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

Hello,
I am having a hard time getting my form(s) to link to the correct tables.

[quoted text clipped - 15 lines]

done.
Thanks,