paul123456
Technical User
heres what i got
tables
client claim
socsecid(pk)--- claimnum
firstnm l---socsecid
md claimamt
lastnm reportedby
suffix initialcontactdate
address1 verifieddate
address2
city
state
zip
phone
tables client and claim have connected by socsecid
i created a form called master with all of the client table and a sub form with all of the claim table.
now what i want to do is at the top of the master form have a field were i can enter the soc and the record of that person pulls up also i would like to have a button that clears all info on the screen and allows for a new entry to be put in. i think that anyone that could help me on this issue deserves a big fat star. Thanks, PAUL
tables
client claim
socsecid(pk)--- claimnum
firstnm l---socsecid
md claimamt
lastnm reportedby
suffix initialcontactdate
address1 verifieddate
address2
city
state
zip
phone
tables client and claim have connected by socsecid
i created a form called master with all of the client table and a sub form with all of the claim table.
now what i want to do is at the top of the master form have a field were i can enter the soc and the record of that person pulls up also i would like to have a button that clears all info on the screen and allows for a new entry to be put in. i think that anyone that could help me on this issue deserves a big fat star. Thanks, PAUL