StaffSergeantK
New member
- Local time
- Today, 10:58
- Joined
- Feb 15, 2008
- Messages
- 1
Gentlemen and ladies(?)
I have a basic question. I have a database that consists of a table of names and dates. I have a second table that has no data but has set fields. I have forms that I created based off of hard copies. Here's what I want to do:
1) I want to be able to enter in a # that calls up all of the data for the fields I've entered on the form. This data already exists in my first table. So, for example, if I entered 123-45-6789 into the # field, all of the other fields would display the data that corresponds with that #.
2) When I write data into a second form I want the fields I've modified to save to my second table. I've done this in InfoPath, but it keeps overwriting my entry with the nest entry I submit, or it creates a new form (form1, form2, form3) for every entry. If I could keep everything in Access I'd be happy.
I've been working on this for awhile and I'm close. It seems like I'm missingsomething - my tables don't link properly, or my info doesn't get called up. I'm shooting from the hip here. Can someone help me out?
I have a basic question. I have a database that consists of a table of names and dates. I have a second table that has no data but has set fields. I have forms that I created based off of hard copies. Here's what I want to do:
1) I want to be able to enter in a # that calls up all of the data for the fields I've entered on the form. This data already exists in my first table. So, for example, if I entered 123-45-6789 into the # field, all of the other fields would display the data that corresponds with that #.
2) When I write data into a second form I want the fields I've modified to save to my second table. I've done this in InfoPath, but it keeps overwriting my entry with the nest entry I submit, or it creates a new form (form1, form2, form3) for every entry. If I could keep everything in Access I'd be happy.
I've been working on this for awhile and I'm close. It seems like I'm missingsomething - my tables don't link properly, or my info doesn't get called up. I'm shooting from the hip here. Can someone help me out?
