Recent content by Kevin Campbell

i'd like to develop some input validation and handling for a form im working on. I have one form consisting of only table for that form (input into only one table). They must input data in one field on the form (required). I have created a simple add button that only adds a new record to...

I'm having design questions for complicated business logic. I have 4 tables, Author, Plan, Analysis, and Report. 1 or many authors can write 0, 1 or many Plans, Analysis or Reports. And a Plan, Analysis and Report (all 3) can all have a 1 or many authors associated with it. So thats the...

Hello, My problem is I have an existing table called customer. The primary key of this table is CustID, an auto-incrementing number with 3 fields, CustName, CustAddress, CustPhone. This table has around 4000 records. I was assigned a new table today that contains only a CustName...

fixed I ended up fixing it. the void subform also iincluded data from 2 other tables that had to be updated. So the Panel form contained a subform that was updating 3 tables at one time. I had to write some VB code for when I clicked on the add button record that it would sychronize the...

Hello. The problem I am having is related to two tables. I have a table called Void and a table called Panel. A panel can have multiple voids and a void is assigned to only panel (one-to-many). In the Panel table, I set an autoincrementing number(SprayPanelId) for the pK. In the Void table...