Flexible Form

[uivandal]

I had this posted under another question but finally figured out how to post it separately....sorry for any confusion.


FLEXIBLE FORMS QUESTION:

I am trying to set up a flexible form and not hard coding information.
I want to be able to allow the user to enter fee information:
tblFees

Fee1 Fee1Description Fee1Amt
Fee2 Fee2Description Fee2Amt
etc. and they can continue to add as many fees as they need.

Then I need to allow them to say how these fees are applied:

SaleItemType1 might need Fee1, Fee2, Fee3 and no other fees
SaleItemType2 might need all of the fees
SaleItemType3 might just need Fee1
etc. for as many SaleItemTypes they may have.

So after applying the fees as they have noted generically for the SaleItems then they may need to go to specific record and make changes just for that record. So for example, Record1 might be a SaleItemType3 that was generically given Fee1 but this specific record needs Fee1 and Fee3. Record25 might be a SaleItem2 that generically got all of the fees but for this record, they want to remove Fee4.

Hope that make sense and that someone can help me. And again, sorry for the posting of two different questions in one post....

UIVandalPatti

 

[uivandal]

This is what the forms look like, basically. At this point I limited the fees to 10.

frmFeeMaintenance
FeeID Fee Description Fee Amt
1 Sale Fee 17.00
2 Building Fund% .02
3 Trucking 2.00
etc. (I would like to allow the flexibility to add as many fees as needed)

frmSaleItemMaintenance
SaleItemType Fee1 Fee2 Fee3 ..... Fee10
Type1 Y N Y ... N
Type2 Y Y Y ... Y
Type3 N N Y ... N
etc. (Would like to be able to populate this form based on the number of fees added)

I do a query update to create the generic Seller fees based on sale item
type. (again...would like to populate this form based on the # fees they have added)

frmSellerFees
SellerID SellerName SaleItemType Fee1 Fee2 Fee3 .... Fee10
1 John Doe Type1 Y N Y ... N
2 Jane Doe Type2 Y Y Y ... Y
3 Jack Sprat Type3 N N Y ... N
4 Jane Sprat Type2 Y Y Y ... Y
etc.

So....if for some reason John Doe, even though he is selling a sale item type = 1 and would generically be assessed Fee1 and Fee3, the user could change the fees just for him if need be.

Hope that makes sense.

For now, I have limited the fees to 10 and created static forms based on those 10 fees. I just was curious if there was a way to allow flexibility to this scenario. Or if I am even approaching this the right way.

Thanks for any help!

( I noticed when I submitted this that all of my nice spacing for my forms got removed.....hope it makes sense.)