Hi,
Here is the scenario of an insertion form:
//table all information will be inserted into
records: recid,name,dte,catCode, pointCode, amt_type, amt, count
//tables that determine correct data to be inserted to records
category: catCode, catName
points: pointcode, pointName, amt_type, amt, count
First, I do not want Records linked back to the Points table. If a point amt was changed and there were 100 records which ref'd that point, it would display an empty field in the amt column from what I've tested out. I use the Amt column to get Totals of the various pointcodes and use the amt_type column to display stats reports on that column as well.
User selects from Category Table list first, that selection determines what shows up in the Points list. This much I actually have already, lol.
User now selects from the drop down list for the Points. I need to get multiple fields of information based on that choice, then I need to get them posted into the records table along with all the other data from the form.
I know there has to be a way to do this. I just need a nudge or an example of some kind that shows the process of pulling 3-4 fields from a dropdown list of a db table and then how those fields get inserted with the POST along with all the other fields from the form. Nobody seems to want to show me how this is done? Or maybe it's just a lack of understanding on my part.
I patiently await any help ANYONE can give me lol.
