spatel
Posts: 10
|
| Posted: 08/18/2004, 1:34 PM |
|
Hello,
I have 2 forms (frmMain & frmFin) and tables associated with them are tblClient & tblFinance respectively. The relationship is 1 to 1 where SSN is primary key in both tables. So for ex. a perticular client can only have one financial record which has there cash, montly income, assets, and so on..
I have it set up so when you first add a new client via frmMain it also creates a blank record for that same person in the tblFinance so then one can go into frmFin and find that person and add/updated their financial info.
Problem: I am trying to bring up the same record from frmMain to frmFin when I hit the "Financial Info" button; however the frmFin opens up from the first record (default). Ex. If the current record is ssn# 222-22-2222 on frmMain then when I hit "Financial Info" button it should bring up that same record from tblFinance and onto frmFin.
|
 |
 |
spatel
Posts: 10
|
| Posted: 08/18/2004, 1:35 PM |
|
|
|
|
|
|
