Is it possible to enter new records? Advanced SQL needed?

[sanlejushi]

Hello all

When we use Access to create a database, and fully normalise it, we would have lots of many seperate entities (tables). That's a hassle when it comes to updating, isn't it? I would need to open up many different tables update the records.

Is it possible create a form, that enables new records to be entered into the various related tables?

e.g. a form with fields that allows updating of customer informtation, sales information, etc...where all these are seperate entities linked by a sales invoice # which is the primary key...

Is there any way a novice user can do it?

 

[WillR]

Re: Is it possible to enter new records? Advanced SQL needed

Surely you'd just want to update your sales information and link the "sale" to a specific customer by entering a CustomerId... if indeed your database is fully normalized...

I don't fully understand the "hassle" of the separate tables....

TblCust ... customer info (CustomerId = primary key)
CustomerId, Contact, Tel, Address etc

TblSales (InvoiceNo = Primary Key... linked to TblCust on CustomerId)
InvoiceNo ,CustomerId, Item, Volume, Value (very basic eg)

If you want to enter an invoice, use on form for that - it can be populated automatically with customer info, driven by the selected CustomerId

If you need to amend Customer details (such as address), you'd have a separate AmendCustomer form...

Hope this helps
Will