General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Essentially I have a form which are tied to several tables. For instance I have an orders and client table which are related thru clientid id. When I want the user to add a new record I do the following. I add a new record to the client table which get an id from a stored procedure in the dbc. Then I do an insert into the orders table replace the clientid in the orders with the id from the clients table. There is also a stored procedure in the orders table that put in a new id in the orders table that for an order number. I then select the orders table get the recno number skip and then go back to record number I've saved. This is where the table/field validation gets fired. I am using row buffering on the orders table and table buffering on the client table. Actually one order can only have one client. Any thought you have are appreciated. As far as what is in the dbc for each table - I have it so that a particular field can't be empty.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only