W
wjcoates
Guest
Hello.
I am a first-timer so please be gentle.
I purchased Access for Dummies books hoping it would cure me of my dumbness. Unfortunately this is not the case and I turn to you out of desperation more than anything else, after weeks of frustration trying to get a simple database to do what I need it to do.
In the early 80's I designed a number of databases for my insurance business using FilePro and Profile. I understand the concept of relational databases, lookups and how to build an efficient DB and I have done so many times in the past, but only in FilePro and ProFile, both programs from the Small Computer Company.
Unfortunately they did not survive the Windows revolution and I have tried to master Access several times and always get stuck in the same place more or less.
I have an insurance business, an industry ripe for databaseing and I have set up the following tables, forms and reports.
tblclientdata Client basic info (28 fields) Primary key=custfile
tblLLdata Basic policy info (8 fields) Primary key=custfile
frmclientdata Used to input and view a client record
frmLLdata Used to input LL (policy) data. This is set up as a subform also on frmclientdata.
rptLLcontract LL document. This is an insurance policy document providing marine emergency expense coverage under the Trade Name "LifeLine".
Not all records have LifeLine policies.
We intend to add other products to our forms once we get the present LL-related problem solved.
What happens now.
I open a record and view on frmclientdata the information I have entered previously on frmclientdata. On the subform I can see matching records that have data in frmLLdata. Where no data exists the fields are blank or have default values, so that part works.
1)- I have a button on the frmLLdata that should Open the matching rptLLcontract in Print Preview but when it opens the wrong record is displayed and I have to scroll through the LLdata base to find the correct form. In other words, I cannot get the rptLLcontract to produce the matching form.
2)- I am trying to display on rptLLcontract the LastName, FirstName and other fields from tblclientdata to show the usual Customer Info such as Name, Address, etc stored in tblclientdata. I can get them in a table called qry1 but I do not know how the display them on the report. I have set up a field called LastName on rptLLcontract but I get errors that the form cannot find the information to display it.
Can someone help.
I am a first-timer so please be gentle.
I purchased Access for Dummies books hoping it would cure me of my dumbness. Unfortunately this is not the case and I turn to you out of desperation more than anything else, after weeks of frustration trying to get a simple database to do what I need it to do.
In the early 80's I designed a number of databases for my insurance business using FilePro and Profile. I understand the concept of relational databases, lookups and how to build an efficient DB and I have done so many times in the past, but only in FilePro and ProFile, both programs from the Small Computer Company.
Unfortunately they did not survive the Windows revolution and I have tried to master Access several times and always get stuck in the same place more or less.
I have an insurance business, an industry ripe for databaseing and I have set up the following tables, forms and reports.
tblclientdata Client basic info (28 fields) Primary key=custfile
tblLLdata Basic policy info (8 fields) Primary key=custfile
frmclientdata Used to input and view a client record
frmLLdata Used to input LL (policy) data. This is set up as a subform also on frmclientdata.
rptLLcontract LL document. This is an insurance policy document providing marine emergency expense coverage under the Trade Name "LifeLine".
Not all records have LifeLine policies.
We intend to add other products to our forms once we get the present LL-related problem solved.
What happens now.
I open a record and view on frmclientdata the information I have entered previously on frmclientdata. On the subform I can see matching records that have data in frmLLdata. Where no data exists the fields are blank or have default values, so that part works.
1)- I have a button on the frmLLdata that should Open the matching rptLLcontract in Print Preview but when it opens the wrong record is displayed and I have to scroll through the LLdata base to find the correct form. In other words, I cannot get the rptLLcontract to produce the matching form.
2)- I am trying to display on rptLLcontract the LastName, FirstName and other fields from tblclientdata to show the usual Customer Info such as Name, Address, etc stored in tblclientdata. I can get them in a table called qry1 but I do not know how the display them on the report. I have set up a field called LastName on rptLLcontract but I get errors that the form cannot find the information to display it.
Can someone help.
