Ok, I read through the relational tutorial and now have some things to go through, and ask.
I have two db's. Both will have records with Userid in it. In one db this is the key field (so i guess that makes this db the one side). The other db will have ID#'s as the key field, and Userid as another field. This will be the many side because Each userid will have many ID#'s associated with it.
In Reply To:
You can not use the autogenerate feature for this modification.
Why exactly is that? And does this only apply to forms for inputing and not viewing?
If only for inputing, then no problem!
Let's move on to say that I would like to be able to have all fields available from both db's for my output.
Is this possible?
Here is some more detail......
2 db's - one is user info with fields like name, address, email, etc.....
The other has info looking like what I put in my calculations question
ID Userid Field1 Value1
1 xyz item1 100
2 xyz item1 100
3 xyz item2 200
4 abc item1 100
5 cdf item2 200
6 cdf item2 200
7 cdf item3 300
This info needs to be displayed two ways. First as the calculation -- See:
http://www.gossamer-threads.com/...ew=&sb=&vc=1 Then as itemized, like above, however only those records that match the current user (only view own records) can be viewed.
So for user 'cdf' I will end up showing:
User: cdf
Real Name
Address
Email Address
item1 Total 0
item2 Total 400
item3 Total 300
Grand Total 700
Or, there's the option to view it like this:
User: cdf
Real Name
Address
Email Address
item2 200
item2 200
item3 300
Grand Total 700
Probably ignoring the calculations for now, and just getting to the point that I can show the itemized (without grand total) to start......what should I do?
I'm going to keep reading over the tutorial for now....
Thanks!
Adam
-------Added to post:
Is it possible to have a single html.pl? Or, should I have one html.pl for the calculated one and then another for the itemized one?