Can I list from 2 tables or qrys in 1 form?

D

dennisW

I'm Working on a ~ simple database to track in-stock inventory, orders placed
+ ordered items received. The P.O.# on the boxes (generated with orders from
corp. ordering software) helps but with everyone in the lab placing orders,
still confusing as the boxes are received. We also get caught with no
stock, prompting panic orders.
Thanks Allen, Steve for help but still a bit stuck. I checked Northwinds &
on-line examples - awesome examples & links but not able to use this to solve
this.
I have Product, Supplier, Order tables, related by SuppName (Product,
Supplier) & autonum field Itemnum (Product, Order). I want users to see
ordered items not yet received + # currently in stock so it's clear if no
need to order more of that item. I also want to enter info from corp.
ordering software to create new Order records and I want to see this on the
same form. (I'll delete the Order records when items arrive after increasing
lab inventory). I used a list box on the form to show current orders (Orders
qry [Product + Order tables]: Itemnum, ProdName, OrderDate, POnum,
NumOrdered). Once currently ordered items checked, I want to create a new
Order table record: user selects from the Product table records, if one
exists (ProdName, SuppName, Size shown) to avoid spelling, naming errors or
enter new order data if it doesn't exist in Product.
I tried using a subform as in Northwinds but no go, even with an
OrderDetails table joining Product + Order. Also tried a combo box (Product
table or qry) hoping I can select the Product item, enter other order stats &
add it to the Order table. Briefly saw Product records but couldn't
select+save them. Can I not easily do this on the same form - list (no
edit) from 1 source then select a record from 2nd source (or create a new
record in 1st table if not a 'stock item' in 2nd table) and add it to 1st
table? Once done, I hope to be able to change copy & this to make "Items
received-add to inventory" selection. Scrambling to learn some some VBA so
I can use this if I need it. I saw advice to calc inventory using changes to
stock but no one has indeas on what stock we have now. Any ideas
appreciated. thanks.
 
T

Tom Wickerath MDB

you will need to move to Access Data Projects in order to be able to use a
query and consistently update records

with ADP you can utilize 'instead of triggers'

Access MDB doesn't have any functionality like this
 
6

'69 Camaro

Everyone please note that Aaron Kem.pf is attempting to impersonate one of
our regular posters again. Tom would never post such a message.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.


Tom Wickerath MDB said:
you will need to move to Access Data Projects in order to be able to use a
query and consistently update records

with ADP you can utilize 'instead of triggers'

Access MDB doesn't have any functionality like this


dennisW said:
I'm Working on a ~ simple database to track in-stock inventory, orders
placed
+ ordered items received. The P.O.# on the boxes (generated with orders
from
corp. ordering software) helps but with everyone in the lab placing
orders,
still confusing as the boxes are received. We also get caught with no
stock, prompting panic orders.
Thanks Allen, Steve for help but still a bit stuck. I checked Northwinds
&
on-line examples - awesome examples & links but not able to use this to
solve
this.
I have Product, Supplier, Order tables, related by SuppName (Product,
Supplier) & autonum field Itemnum (Product, Order). I want users to see
ordered items not yet received + # currently in stock so it's clear if no
need to order more of that item. I also want to enter info from corp.
ordering software to create new Order records and I want to see this on
the
same form. (I'll delete the Order records when items arrive after
increasing
lab inventory). I used a list box on the form to show current orders
(Orders
qry [Product + Order tables]: Itemnum, ProdName, OrderDate, POnum,
NumOrdered). Once currently ordered items checked, I want to create a
new
Order table record: user selects from the Product table records, if one
exists (ProdName, SuppName, Size shown) to avoid spelling, naming errors
or
enter new order data if it doesn't exist in Product.
I tried using a subform as in Northwinds but no go, even with an
OrderDetails table joining Product + Order. Also tried a combo box
(Product
table or qry) hoping I can select the Product item, enter other order
stats &
add it to the Order table. Briefly saw Product records but couldn't
select+save them. Can I not easily do this on the same form - list (no
edit) from 1 source then select a record from 2nd source (or create a new
record in 1st table if not a 'stock item' in 2nd table) and add it to 1st
table? Once done, I hope to be able to change copy & this to make
"Items
received-add to inventory" selection. Scrambling to learn some some
VBA so
I can use this if I need it. I saw advice to calc inventory using
changes to
stock but no one has indeas on what stock we have now. Any ideas
appreciated. thanks.
 
D

dennisW

Thanks Gunny (& Tom?). Still unsure of a solution but your links look great;
will plow through again to see if I can't see something that applies to my
situation. I really thought this was a simple database exercise even for a
beginner like me but can't get past these snags.
Dennis
'69 Camaro said:
Everyone please note that Aaron Kem.pf is attempting to impersonate one of
our regular posters again. Tom would never post such a message.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.


Tom Wickerath MDB said:
you will need to move to Access Data Projects in order to be able to use a
query and consistently update records

with ADP you can utilize 'instead of triggers'

Access MDB doesn't have any functionality like this


dennisW said:
I'm Working on a ~ simple database to track in-stock inventory, orders
placed
+ ordered items received. The P.O.# on the boxes (generated with orders
from
corp. ordering software) helps but with everyone in the lab placing
orders,
still confusing as the boxes are received. We also get caught with no
stock, prompting panic orders.
Thanks Allen, Steve for help but still a bit stuck. I checked Northwinds
&
on-line examples - awesome examples & links but not able to use this to
solve
this.
I have Product, Supplier, Order tables, related by SuppName (Product,
Supplier) & autonum field Itemnum (Product, Order). I want users to see
ordered items not yet received + # currently in stock so it's clear if no
need to order more of that item. I also want to enter info from corp.
ordering software to create new Order records and I want to see this on
the
same form. (I'll delete the Order records when items arrive after
increasing
lab inventory). I used a list box on the form to show current orders
(Orders
qry [Product + Order tables]: Itemnum, ProdName, OrderDate, POnum,
NumOrdered). Once currently ordered items checked, I want to create a
new
Order table record: user selects from the Product table records, if one
exists (ProdName, SuppName, Size shown) to avoid spelling, naming errors
or
enter new order data if it doesn't exist in Product.
I tried using a subform as in Northwinds but no go, even with an
OrderDetails table joining Product + Order. Also tried a combo box
(Product
table or qry) hoping I can select the Product item, enter other order
stats &
add it to the Order table. Briefly saw Product records but couldn't
select+save them. Can I not easily do this on the same form - list (no
edit) from 1 source then select a record from 2nd source (or create a new
record in 1st table if not a 'stock item' in 2nd table) and add it to 1st
table? Once done, I hope to be able to change copy & this to make
"Items
received-add to inventory" selection. Scrambling to learn some some
VBA so
I can use this if I need it. I saw advice to calc inventory using
changes to
stock but no one has indeas on what stock we have now. Any ideas
appreciated. thanks.
 
6

'69 Camaro

Hi, Dennis.

Please start a new thread. Our resident troll has trashed this one. Sorry
for any inconvenience.

Thanks.
Gunny


dennisW said:
Thanks Gunny (& Tom?). Still unsure of a solution but your links look
great;
will plow through again to see if I can't see something that applies to my
situation. I really thought this was a simple database exercise even for a
beginner like me but can't get past these snags.
Dennis
'69 Camaro said:
Everyone please note that Aaron Kem.pf is attempting to impersonate one
of
our regular posters again. Tom would never post such a message.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.


Tom Wickerath MDB said:
you will need to move to Access Data Projects in order to be able to
use a
query and consistently update records

with ADP you can utilize 'instead of triggers'

Access MDB doesn't have any functionality like this


I'm Working on a ~ simple database to track in-stock inventory, orders
placed
+ ordered items received. The P.O.# on the boxes (generated with
orders
from
corp. ordering software) helps but with everyone in the lab placing
orders,
still confusing as the boxes are received. We also get caught with
no
stock, prompting panic orders.
Thanks Allen, Steve for help but still a bit stuck. I checked
Northwinds
&
on-line examples - awesome examples & links but not able to use this
to
solve
this.
I have Product, Supplier, Order tables, related by SuppName (Product,
Supplier) & autonum field Itemnum (Product, Order). I want users to
see
ordered items not yet received + # currently in stock so it's clear if
no
need to order more of that item. I also want to enter info from
corp.
ordering software to create new Order records and I want to see this
on
the
same form. (I'll delete the Order records when items arrive after
increasing
lab inventory). I used a list box on the form to show current orders
(Orders
qry [Product + Order tables]: Itemnum, ProdName, OrderDate, POnum,
NumOrdered). Once currently ordered items checked, I want to create
a
new
Order table record: user selects from the Product table records, if
one
exists (ProdName, SuppName, Size shown) to avoid spelling, naming
errors
or
enter new order data if it doesn't exist in Product.
I tried using a subform as in Northwinds but no go, even with an
OrderDetails table joining Product + Order. Also tried a combo box
(Product
table or qry) hoping I can select the Product item, enter other order
stats &
add it to the Order table. Briefly saw Product records but couldn't
select+save them. Can I not easily do this on the same form - list
(no
edit) from 1 source then select a record from 2nd source (or create a
new
record in 1st table if not a 'stock item' in 2nd table) and add it to
1st
table? Once done, I hope to be able to change copy & this to make
"Items
received-add to inventory" selection. Scrambling to learn some some
VBA so
I can use this if I need it. I saw advice to calc inventory using
changes to
stock but no one has indeas on what stock we have now. Any ideas
appreciated. thanks.
 
B

BruceM

There is an Access MVP named Tom Wickerath who regularly posts sound and
coherent advice in this forum. As Gunny pointed out, the person identifying
himself as Tom in this thread is an imposter. It seems he doesn't
understand Access, so he attempts to trash it.

dennisW said:
Thanks Gunny (& Tom?). Still unsure of a solution but your links look
great;
will plow through again to see if I can't see something that applies to my
situation. I really thought this was a simple database exercise even for a
beginner like me but can't get past these snags.
Dennis
'69 Camaro said:
Everyone please note that Aaron Kem.pf is attempting to impersonate one
of
our regular posters again. Tom would never post such a message.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.


Tom Wickerath MDB said:
you will need to move to Access Data Projects in order to be able to
use a
query and consistently update records

with ADP you can utilize 'instead of triggers'

Access MDB doesn't have any functionality like this


I'm Working on a ~ simple database to track in-stock inventory, orders
placed
+ ordered items received. The P.O.# on the boxes (generated with
orders
from
corp. ordering software) helps but with everyone in the lab placing
orders,
still confusing as the boxes are received. We also get caught with
no
stock, prompting panic orders.
Thanks Allen, Steve for help but still a bit stuck. I checked
Northwinds
&
on-line examples - awesome examples & links but not able to use this
to
solve
this.
I have Product, Supplier, Order tables, related by SuppName (Product,
Supplier) & autonum field Itemnum (Product, Order). I want users to
see
ordered items not yet received + # currently in stock so it's clear if
no
need to order more of that item. I also want to enter info from
corp.
ordering software to create new Order records and I want to see this
on
the
same form. (I'll delete the Order records when items arrive after
increasing
lab inventory). I used a list box on the form to show current orders
(Orders
qry [Product + Order tables]: Itemnum, ProdName, OrderDate, POnum,
NumOrdered). Once currently ordered items checked, I want to create
a
new
Order table record: user selects from the Product table records, if
one
exists (ProdName, SuppName, Size shown) to avoid spelling, naming
errors
or
enter new order data if it doesn't exist in Product.
I tried using a subform as in Northwinds but no go, even with an
OrderDetails table joining Product + Order. Also tried a combo box
(Product
table or qry) hoping I can select the Product item, enter other order
stats &
add it to the Order table. Briefly saw Product records but couldn't
select+save them. Can I not easily do this on the same form - list
(no
edit) from 1 source then select a record from 2nd source (or create a
new
record in 1st table if not a 'stock item' in 2nd table) and add it to
1st
table? Once done, I hope to be able to change copy & this to make
"Items
received-add to inventory" selection. Scrambling to learn some some
VBA so
I can use this if I need it. I saw advice to calc inventory using
changes to
stock but no one has indeas on what stock we have now. Any ideas
appreciated. thanks.
 

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

Top