Access

[Guest]

Are you able to like tables to columns in another table to create on table?

 

[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!)

Are you able to like tables to columns in another table to create on

table?

 

[Guest]

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.

 

[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)

 

[Joseph Meehan]

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.

That is the nature of a relational database, and Access is a relational
database. Your answer is yes.

Assuming you have Access available and that it was installed with the
Northwind example, take a look there. It shows exactly what you are talking
about.