AnsweredAssumed Answered

Add record with check box

Question asked by bigtone on May 29, 2009
Latest reply on Nov 23, 2010 by AlexGodines

Title

Add record with check box

Post

First time poster here but have been using these great forums for a few weeks now building a new database, however I've finally hit a brick wall.

 

I have a relatively simple job, purchasing, product and inventory management system. I based the job system on Filemaker's purchase order template so there is a Job table containing the delivery address etc then a portal which adds records to a Job Line Items table. The Jobs Line Items table in turn looks up product codes and descriptions records from the Product table.

 

What I'm trying to do is create a button that sits next to the Job Line Items in the portal and when the Job is complete you just check the box to book the item out of stock. Thus a new record is created in the inventory table marking the item out of stock. I'm afraid I haven't a clue how to do it.

 

The reasoning behind the check box and not wanting all items to be booked out is certain line items may be a service therefore have no inventory level.

 

Please help.

 

Many thanks 

 

On other thing, it would be ideal, but not essential, if when the check box is unchecked the record is deleted. 

 

 

Outcomes