Need Help With Sales Purchase Ledger Database

[Aamer]

I have made a ledger DB, everything is working fine.... but am stuck with the
delivery challan form.

When I put the company name it does not pick up the details of the company
i.e company address, city and phone numbers.

Can someone please fix my DB

I can mail my Db for fixing.

PLEASE PLEASE Send reply to (e-mail address removed) so i can e-mail the DB.

Help needed urgently.

Regards
aamer sheikh

 

[Graham Mandeno]

Hi Aamer

If you want to email your database to someone and have them fix it, then you
should hire a consultant. This forum is not here to do things for you, but
to help you to learn how to do them for yourself.

Let's assume you have a Companies table, with the company name, address,
phone numbers, etc, and this table has a primary key - CompanyID - which
might be an autonumber.

Now, you will have other tables - for example, Purchases and Sales - whose
records need to be associated with a company record. You do this by storing
only the CompanyID value in the related record - never the company name,
address, etc.

If you wish to show the details of the purchase or sale, along with the
details of the company, then you create a *query*. The query will need to
include both tables, and there will be a join between the CompanyID (primary
key) of the companies table, and the field containing the related company ID
(foreign key) in the other table.