J
JennBard1
Are you able to like tables to columns in another table to create on table?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Douglas J Steele
Do you mean join tables? Say, for instance, you have an Invoice table and
one of the fields in the Invoice table is CustomerNb, can you get the
Customer details from the Customer table? The answer is yes: that's what
Queries are for.
--
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
one of the fields in the Invoice table is CustomerNb, can you get the
Customer details from the Customer table? The answer is yes: that's what
Queries are for.
--
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
table?JennBard1 said:Are you able to like tables to columns in another table to create on
J
JennBard1
What i am trying to do is create a table where i can track jobs, within this
i want o be ble to tell it that i invoiced certain jobs and show the invoice
numbers. The thing is that some Jobs have more than one invoice and so i'm
not really sure how to go about creating a table where i can put in multiple
invoices.
I also want to make a database for purchase orders. In which there are
sometimes multiple items per order but all orders are from the same customer.
i want o be ble to tell it that i invoiced certain jobs and show the invoice
numbers. The thing is that some Jobs have more than one invoice and so i'm
not really sure how to go about creating a table where i can put in multiple
invoices.
I also want to make a database for purchase orders. In which there are
sometimes multiple items per order but all orders are from the same customer.
D
Douglas J Steele
All of what you're describing is certainly possible to do within Access.
However, recognize that you'll have to design the database to support what
you want, plus generate forms, reports, queries, etc. Out of the box, Access
doesn't give you anything other than a development environment. (Okay,
that's not 100% true: there are some templates that can be used to create
databases)
However, recognize that you'll have to design the database to support what
you want, plus generate forms, reports, queries, etc. Out of the box, Access
doesn't give you anything other than a development environment. (Okay,
that's not 100% true: there are some templates that can be used to create
databases)