FORMS

[Guest]

Hi again!

I have two tables. I want the email values from table 1 to also go into
table 2.

I have already established a relationship for the Name in table 1 to go into
the Name in table 2.

Is it possible to add on to that relationship and have the name and email
from table 1 update to the name and email in table 2?

Hope that makes sense
Ransom

 

[RBear3]

Why? That is redundant. If you already have the two tables linked, then
you don't need redundant fields in both tables. If you need a person's
email, then pull it from table 1.

You also should not be storing name in both (unless that is the key field
you are using to link the two.) Typically you would have some other numeric
field to use as a link. Since names would typically be stored in two or
more fields ([FirstName], [MiddleName], [LastName], etc.) it requires
linking the tables based on multiple fields (which can get cumbersome as you
move along and create additional more complex queries, forms, and reports.

I'd suggest you step back and normalize your data. That would mean getting
rid of redundant fields, making sure each field contains only one piece of
data, making sure your field names and table names do not include data, etc.

 

[Guest]

Yes, that helps and I seem to always get into these linking tables issues.

The database is set up so that I can see how many people made nominations.
For example. Ransom nominated 5 different people for 5 different positions.

So, I created two tables one stores the information of the person who made
the nomination (Ransom) and the other holds the information of the nominated
people.

On my form, you see the information about the nominator and at the bottom,
you see the information about the nominee and its attatched to that specific
nominator.

Ultimately, what I want to do is be able to email the nominator to indicate
whether or not the nomination is valid and if it's not, I need to list why
etc...

any suggestions would be appreciated.

Ransom

Why? That is redundant. If you already have the two tables linked, then
you don't need redundant fields in both tables. If you need a person's
email, then pull it from table 1.

You also should not be storing name in both (unless that is the key field
you are using to link the two.) Typically you would have some other numeric
field to use as a link. Since names would typically be stored in two or
more fields ([FirstName], [MiddleName], [LastName], etc.) it requires
linking the tables based on multiple fields (which can get cumbersome as you
move along and create additional more complex queries, forms, and reports.

I'd suggest you step back and normalize your data. That would mean getting
rid of redundant fields, making sure each field contains only one piece of
data, making sure your field names and table names do not include data, etc.

--
Hope that helps!

RBear3
..

Hi again!

I have two tables. I want the email values from table 1 to also go into
table 2.

I have already established a relationship for the Name in table 1 to go
into
the Name in table 2.

Is it possible to add on to that relationship and have the name and email
from table 1 update to the name and email in table 2?

Hope that makes sense
Ransom