I need help with a report where i need 2 or more tables/queries.
I have a simple Db which I am practicing on and want to create a report that looks like an Invoice. I,ve created a parent report from a query to get Customer details etc and a Sub report from a query with Billing Details.
My problem is I can,t get the link to work, I have watched tutorials and as far as I can see done every thing correct. I know the problem is with the relationship or Master Link Field/Child Link Field I just cant,t work it out.
It,s driving me crazy is there anyone out there willing to look at my Db and show what I am doing wrong.
I like your suggestion for the layout and will have a go at it. First I need to sort out the missing ID,s.
I have had this problem before so should have seen it, however I don,t know how it happened, any suggestion? As you can see from the amount of customers that I copied the tables from a previous Db I created and was just using it to practice some new techniques I have been learning. I assume that if I created a new Customer the ID,s would be there, need to test that.
Would appreciate your comments on the following:
1/ Do I have the PK and FK correct in each table
2/ Is there an easy way to put the missing ID,s in the tables, maybe a query
3/ Confused on why, if there are missing ID,s my forms work, for example, I can move from Customer Details to Work Schedule and then to Billing and the data is correct.
Thanks for your help,advice and suggestions they are much appreciated.
I will go back a few steps and correct my errors, sometimes a fresh pair of eyes work wonders. I am angry with myself that I did not see the errors, now I know I need to work out what I did wrong when I copied the tables over.
I have reduced the number of records so it will be easier to work with and correct any errors, later I will work out how to import all the records.
Again many thanks and I will let you know my progress.