Data entry on the fly

  • Thread starter isons via AccessMonster.com
  • Start date
I

isons via AccessMonster.com

Hello Everybody!

I have a database containing tables Customers, Orders, Quotations, Suppliers
etc.

Fields in Orders tables are

OrderID
Date
PartNo (Lookup field)
Description
Price
Qty etc

PartNo field is a lookup field from products table. In my order entry form
when I enter Part No it lookup data in the products table and fills the form
with relevant data. If PartNo is not found in products table it displays
error message. I want to fill new entry on the fly in orders table and at the
same time I want my products table be updated with the new entry as well.

Please help
 
J

jahoobob via AccessMonster.com

Try this:
http://allenbrowne.com/ser-27.html
Hello Everybody!

I have a database containing tables Customers, Orders, Quotations, Suppliers
etc.

Fields in Orders tables are

OrderID
Date
PartNo (Lookup field)
Description
Price
Qty etc

PartNo field is a lookup field from products table. In my order entry form
when I enter Part No it lookup data in the products table and fills the form
with relevant data. If PartNo is not found in products table it displays
error message. I want to fill new entry on the fly in orders table and at the
same time I want my products table be updated with the new entry as well.

Please help
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Fill in multiple fields with one lookup 0
Update box with combo box 2
automatically create new record in lookup table if data does not e 9
Newbie needs help with table 1
adding records to a sub form 2
Order entry form using data from a second table 5
cant add data 4
Order Entry 3

Top