How to enter a Body of Text

[Guest]

How do i store a big body of text like a product description?
I cannot separate the data because I need to use the whole block for my
contract generation.

While i'm at it, I must be missing the logical procedure access takes to put
together a sales contract or purchase contract.
If i create a sales contract(report) do i use the fields from the customers
table, or create a query to get the customer id from order details and in
turn get the customer info from the customer tables.
Sorry for the newbie question, i'm having a hard time pulling my thoughts
together to really grasp this program.

 

[Douglas J. Steele]

For your first question, use a Memo field.

I'm not sure I understand your second question. Where you get your
information from depends on what information you need, and where it's
stored.

 

[Guest]

Thank you for the 1st answer.

Well i have an order form which enters data into an order table, and a
subform to enter info into order details. Now for my reports i only gather
some of the fields from both of those tables as well as standard info from
customers and suppliers table(such as address, phone, contactname). Now my
question is how does all this information get pulled together for the same
order. Like if i generate a report for order 1234 how does it know that
customer 12 bought it. I'm probably answering my own question but does it
only need the customerid and supplierid to pull together the right info?

Wow i've even confused myself.

 

[Douglas J. Steele]

Presumably either your Order table has a foreign key that points back to the
Customer table, or else you've got an intersection table between the two
that has both OrderID and CustomerID as its primary key. You should be able
to create a query that joins your various tables together.

If you've already got a report that has the information you need, take a
look at the report's Record Source. That'll give you an idea of how it's
connecting the information.