Hi all, I'm new to the forums and fairly new to Access (self-taught) and I am completely stuck. I've been trying to sort my problem with my database out for what feels like weeks and I'm conscious that I'm wasting WAY too much time because I'm clueless, basically! 
So I thought I'd see if anyone here could help.... apologies in advance for my 2nd and long post!!!!
My project is as follows:
Objective: to keep a database of products which have been prescribed by various advisors, and issued by pharmacies, and their total cost, inclusive and exclusive of handling and prescription fees. (I thought it sounded fairly simple.)
I have so far split the database into the following tables:
Products (ProductName and Price);
Handling Fees (FeeName and Cost);
Pharmacies (Name and address);
Advisors (Name)
To pull all these together, and make them useful, I would then have my "vouchers" table / form:
VoucherDetails (Voucher number, date issued, quarter - plus the info below).
The voucher table/form ALSO then needs to contain the pharmacy name, the advisor name, and up to 3 products which have been prescribed. People can have a maximum of 3 products and a minimum of 1. It then needs to have the combined cost of those products with and without the handling fees. I also need to have something where I can take off the cost of the prescription fee if that has already been paid (so something like A+B+C = D but subtract E if F is ticked sort of thing).
I have tried one-to-many relationships, many-to-many using the tblVoucher as my "junction" table and I'm just not getting anywhere with it. :banghead:
Does any of this make sense? If I were to upload my sample database would anyone be willing to have a look at it for me and tell me what/where I've gone wrong?
Many thanks - I would so appreciate it if anyone could help me!
Jax
PS apologies if this is the wrong bit of the forum, I'm hoping I'm in the right place.
So I thought I'd see if anyone here could help.... apologies in advance for my 2nd and long post!!!!My project is as follows:
Objective: to keep a database of products which have been prescribed by various advisors, and issued by pharmacies, and their total cost, inclusive and exclusive of handling and prescription fees. (I thought it sounded fairly simple.)
I have so far split the database into the following tables:
Products (ProductName and Price);
Handling Fees (FeeName and Cost);
Pharmacies (Name and address);
Advisors (Name)
To pull all these together, and make them useful, I would then have my "vouchers" table / form:
VoucherDetails (Voucher number, date issued, quarter - plus the info below).
The voucher table/form ALSO then needs to contain the pharmacy name, the advisor name, and up to 3 products which have been prescribed. People can have a maximum of 3 products and a minimum of 1. It then needs to have the combined cost of those products with and without the handling fees. I also need to have something where I can take off the cost of the prescription fee if that has already been paid (so something like A+B+C = D but subtract E if F is ticked sort of thing).
I have tried one-to-many relationships, many-to-many using the tblVoucher as my "junction" table and I'm just not getting anywhere with it. :banghead:
Does any of this make sense? If I were to upload my sample database would anyone be willing to have a look at it for me and tell me what/where I've gone wrong?
Many thanks - I would so appreciate it if anyone could help me!
Jax
PS apologies if this is the wrong bit of the forum, I'm hoping I'm in the right place.
) and someone will likely help you out.
