Can't Figure out the problem in my code when Opening a form

[SD23]

Table 1 and Table 2 are not linked. It is just that the ID, name, and date of form1, all automatically get transferred to form 2. So they get inputted in table 2.

For example
If I put "Sam" for the name in form1. Sam gets inputed in the name field of table 1. When I submit the form1, the name "Sam" automatically gets inputed to Form2. So on table 2, the name "Sam" is inputted in the name field.

Does this mean I have a normalization problem and if so how can i fix it?

 

[Banana]

Yes; if you have to put Sam in two places, it's a normalization problem. The only repeating data in any database should be nothing but keys.

Exactly how do you want your table2 relate to your table1?

Is it a lookup table? Is it supplementary information to the record?

 

[SD23]

it is supplementary information to the record. .

 

[Banana]

Okay-

If the table 2 is supposed to describe optional attributes of records in table 1 which won't change for long time or isn't added/removed to (e.g. more personal information such as credit card history, salary, job position or the like), then you need either only one table with both information or a one-one relationship.

If table2 contains data that are dependent on other factors (e.g. you are counting a visit, hours or quantity of something on a given order), then it should be a one-many relationship with table1's key being a foreign key in table2 to allow table1 to hold several different instances of same data (e.g. on different days or in different orders and so on).

Read up on normalization and relationship to learn more.

 

[SD23]

ok so I got it. For future reference for other I added

DoCmd.OpenForm "Dockets Data Input Form", acNormal, "", "", , acNormal
DoCmd.GoToControl "Patent Type"
DoCmd.FindRecord Forms![Invention Disclosure Input Form]![dsuf]

to my onclick event.

If I want to add another field so it searches for "dsuf" and "dpre", does anyone know how to that? Thanks Banana and Rural Guy for your help.