Re: Sales Offer Summary Database

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

I do have the tables built - however Ken implied not to use tables when I
build my forms. See where my confusion comes in?

My issue is - tables have been created - I create my form use "Commercial
Manager" as parent then I create my subform using my query I built for the
Project Details. I want to be able to click on the Commercial Manager's name
and their projects pop up.

"Evi" wrote:

Is this like Mrs Beaton's recipe for Hare Soup which starts off with the
misleadingly simple instruction 'First catch Your hare'? Al is assuming (as
I did) that you have created your tables and are now trying to input the
data.

Start off by creating the tables. Make sure that you have the structure
right.
Use the Design View, not that silly Datasheet View. Creating the tables
means putting the field names there, deciding the types of data you will
enter there (date, number, text, Yes/No etc then linking the tables in the
Relationships window. You will now have a blank table on which to base your
form.

Only when you have created the table structure, do you think about creating
the forms so that you can input data.



Evi



"Evi" <evwool@xxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:Wc1Nj.68303$jH5.43662@xxxxxxxxxxxxxxxxxxxxxxx

This is really confusing Debb. You started off by saying that you have
some
tables and even named their fields. Now you are saying that you don't have
tables???
Evi

.
"debb66" <debb66@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:6ABD27C8-0877-47CA-B91E-9D9306237693@xxxxxxxxxxxxxxxx
Forgive my ignorance but what will I build my form off of if I don't
have
tables? I tried creating a query based off of expressions and I keep
getting
a circular error.

"Ken Snell (MVP)" wrote:

Use a form with subforms to show the data the way you want..... don't
try to
do it in a table.

--

Ken Snell
<MS ACCESS MVP>


"debb66" <debb66@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:8231E394-B4B0-4889-8A0A-E970EC99D04F@xxxxxxxxxxxxxxxx
I want to build a simple database..

All tables will be linked to a Commercial Manager

There will be three tables

Commercial Manager containing:
CommercialManager ID (Auto-number) Primary Key
Commercial Manager Name

Project Table containing:
ProjectNameID (Auto-number) Primary Key
CommercialManager ID
ProjectName
Region

Project Detail Table containing:
ProjectDetailID (Auto-number) Primary Key
CommercialManager ID
Scope
Price
Cost
Date Approved
Approved By

My issue - I link all the tables together but I want everything to
be
linked
to the commercial managers name so when I create my form it will
pull
up
only
those Projects and Details that are related to the Commercial
Manager
Name.

I can't get this to work and I'm sure it is a simple event I'm
missing.

Thanks to anyone that can help!









.

Relevant Pages

  • Re: Sales Offer Summary Database
    ... prices given out by what manager. ... you would just add a second subform or have one subform filtering ... Project Details. ... All tables will be linked to a Commercial Manager ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Sales Offer Summary Database
    ... can't you just associate the manager to the Project Details ... "Evi" wrote: ... All tables will be linked to a Commercial Manager ...
    (microsoft.public.access.tablesdbdesign)
  • RE: Quota Alternative
    ... Manny is correct here. ... Volume Manager, but it does not have any additional functionality than the ... built in MS one has. ... >> management of quotas? ...
    (microsoft.public.windows.server.general)
  • Re: Deep Impact Kicks Off Fourth of July with Deep Space Fireworks
    ... :>The real irrationality is confusion of power with rationality as if the ... :>boss could everywhere trump rationality with "think like a manager and ... and a manager. ...
    (sci.space.policy)
  • Re: Datagridview doesnt update current row values
    ... confusion. ... You may create a new WinForm application project to ... Microsoft Online Community Support ... You can send feedback directly to my manager at: ...
    (microsoft.public.dotnet.languages.vb)