Datasheet subforms.....

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi Folks,

I have a little database of customers, products, orders, and
order_products.

Although I probably wont end up importing the 6 different product
excel files that I get into the database daily, because its just too
hard for me, and they all have different fields etc etc.... but i
digress.

What I essentially want to do is be able to keep a liist of my
customers and the work (different jobs) I do for them.

I have the customer table and customer entry form sorted.

What I am struggling with is the order form. As I understand it I
should have a form with a subform on it. I have been doing this by
creating a query and dragging that onto the form, but is there a
easier way?


The subform will be all the items on the order, plus a few fields
which need to be calculated like profit (RRP-mybuy).

How do I do this calculated field?

These items wont be bound to anything since there is nothing in the
products database, but as I add items to the order it may as well
update the database.


Hope this all makes sense?

I need some help.

Cheers

-Al

.

Relevant Pages

  • RE: Store Added Value List Items
    ... You could even union that query with the actual list from the form ... Each user in this database needs to have access to all the same customers. ... is praticle to create a seperate one field table to store values for a lookup ...
    (microsoft.public.access.formscoding)
  • Re: Please suggest relationships model
    ... Providing Customers A Resource For Help With Access, ... However, if he wanted his database quick and painless, I provided ... Here you are in the newsgroup offering services that were NOT ASKED for. ... the newsgroups and a few larger jobs. ...
    (microsoft.public.access.queries)
  • RE: Store Added Value List Items
    ... (The Primary Key that the user updated added) ... Each user in this database needs to have access to all the same customers. ... is praticle to create a seperate one field table to store values for a lookup ...
    (microsoft.public.access.formscoding)
  • Re: Corrupt WMP Metadata files
    ... The time and effort that my customers ... into creating their music databases has signficant intrinsic value. ... Windows Media Player databases have intrinsic value to WMP users. ... "I was wrong when I said that the media player database has no ...
    (microsoft.public.windowsmedia.player)
  • Re: Does D3 get any new sales?
    ... exists today in order to fund products for customers other than D3 ... does not seem to be as healthy as other MV database providers. ... Automotive Dealer Management System market worldwide. ... existing and ever declining user base. ...
    (comp.databases.pick)