I have the following tables:
table 1: b_bills (master)
table 2: b_orders (details)
STEP 1
If users want to order 1 or more items, they have to first 'open' a bill.
Within the bill they can add the needed items in the details page b_orders.
STEP 2
Now the items should be assigned to one of these categories:
a. tour
b. stock
Wen they choose the category 'tour', they further have to assign a 'tour number'and then the process stops there.
STEP 3
However, when they choose the category 'stock', they have to further assign to which department this stock belongs:
a. **inventory, with further selecting***
- shop LOLO
- shop LALA
- boat
b. repairs
1. shop LOLO
- shop LALA
- boat
c. equipment rental
1. goggles nr
- mask nr
d. sales
1. shop LOLO
- shop LALA
- boat*
Until STEP 1 all is fine.
Regarding STEPS 2+3 I've created several additional more tables with relationships and it all works out. But, in the master page, users now fill out the b_bill form and the additional b_orders form, but after that I think it looks very confusing for a user (and even to myself!). They have to choose out of several attached 'detail pages'. They see all related detail pages but do not have to fill out all.
Because I am new to PHPrunner and to writing databases, I think I did not follow a logical way. Could somebody give me some tips? I would be thankfull! <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=17381&image=1&table=forumtopics' class='bbc_emoticon' alt=':)' />
Pim