Data/Table Structure Help Needed

[Meilyne]

Hi Experts ... I need a bit of help figuring out the best way to accomplish the following ..

- I have a table named "Food Contracts" which has a record for each food item available in a kitchen and listing 2 methods they are sold in (example : Item ABC - Oranges - Unit 1 = LB, Unit 2 = Carton (138 LBS)

- I have another table named "Kitchens" which has a record for each kitchen for the client - name, address, etc. (basic contact info)

Here is what I'm looking for. Each month the kitchens, currently, get a manual printout of all items listed in the food contracts and they just write down the quantity they have of each - so most lines won't have anything written next to them. The client wants to have this as part of their database (and kitchens will be completing this via web/php pages). Obviously this data will go into a seperate table listing the kitchens id, the food id, the quantity etc. My dilema is how to get them a list they can check off without creating blank records in the new inventory table.

I was just going to give them a drop down list showing the items available in food contracts but the clients wants them to see the list of all items just as they do on the paper printout.

Am I making sense?

Windows XP - FM 9.03 Advanced

Thanks all!!

Sue Carter
J&S Database Solutions
Ottawa, ON
_______________________________________________
FMPexperts mailing list
FMPexperts@...
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

[Steven Thoms-3]

Sue,

Since the interface is independent of the database in a web application,
you have much more flexibility.
In the web application, the form the kitchens use can contain all the
items in any order you please.
When the form is submitted, records would only be created for items with
positive quantity values.

I hope this helps,

Steve


Meilyne wrote:

> Hi Experts ... I need a bit of help figuring out the best way to accomplish the following ..
>
> - I have a table named "Food Contracts" which has a record for each food item available in a kitchen and listing 2 methods they are sold in (example : Item ABC - Oranges - Unit 1 = LB, Unit 2 = Carton (138 LBS)
>
> - I have another table named "Kitchens" which has a record for each kitchen for the client - name, address, etc. (basic contact info)
>
> Here is what I'm looking for. Each month the kitchens, currently, get a manual printout of all items listed in the food contracts and they just write down the quantity they have of each - so most lines won't have anything written next to them. The client wants to have this as part of their database (and kitchens will be completing this via web/php pages). Obviously this data will go into a seperate table listing the kitchens id, the food id, the quantity etc. My dilema is how to get them a list they can check off without creating blank records in the new inventory table.
>
> I was just going to give them a drop down list showing the items available in food contracts but the clients wants them to see the list of all items just as they do on the paper printout.
>
> Am I making sense?
>
> Windows XP - FM 9.03 Advanced
>
> Thanks all!!
>
> Sue Carter
> J&S Database Solutions
> Ottawa, ON
> _______________________________________________
> FMPexperts mailing list
> FMPexperts@...
> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
>
>
>  

_______________________________________________
FMPexperts mailing list
FMPexperts@...
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au