Results 1 to 1 of 1
Nov 19, 2004, 07:48 #1
- Join Date
- Jun 2001
- Harlow, Essex, UK
- 0 Post(s)
- 0 Thread(s)
Help With MySQL Database Structure
Firstly, this will be developed in MySQL & PHP
QRF q_id q_date q_qty1 q_qty2 SUPPLIERS s_id s_company s_email RESPONSES r_id s_id r_date r_qty1 r_qty2 QRF2SUP q_id s_id Q2S_date RES2QRF r_id q_id
The suppliers can then log in and check from their computers which QRF's they need to reply to. For starters I only want them to be able to see outstanding QRF's and not ones they've filled in previously. When they complete the RESPONSE form, the information will be saved in the RESPONSES table and also in RES2QRF lookup table.
Does this look like a well structured database, or should I scrap the RES2QRF table and include the q_id in the RESPONSES table?
I'm hoping this will cut down on my huge workload that I have to deal with everyday of my pityful worklife.