ad post and related fields

M

Maria

This seems like such a simple thing to do but I just can't seem to get
started. I want to create a query that allows me to enter the Name and
despription in one table by typing it by hand when asked to.

It should add the counter automatically and then it should create
related posts referring to that ID in the related tables and ask me to
enter the values for those.

The tiong is I can't even get started on adding to the main table... I
tried typeing [xxx] in the condition field but when i ran the question
it automatically wanted to enter 140 posts without asking me what to
enter so that can't be the way.

/Maria
 
D

Duane Hookom

Do you have some table and field names you could share with us? Also, try to
explain better the functionality you are hoping to achieve.
 
M

Maria

It's all in swedish so I'm not sure if it helps but here are som of my
table and field names.

Table: Huvudtabell
Fields: ID
Namn
Syfte

Table: PDF-er
Fields: ID
PDF
InDesign

Table: Bildoriginal
Fields: ID
Bildfil

ID is the field were they all relate and Huvudtabell is the main table
containg the primary key.

What I wanna do is that when I add a field to Huvudtabell Access ads a
field with a matching ID to the other tables and asks me if I wanna
fill in the file names.






Duane Hookom skrev:
Do you have some table and field names you could share with us? Also, try to
explain better the functionality you are hoping to achieve.

--
Duane Hookom
MS Access MVP

Maria said:
This seems like such a simple thing to do but I just can't seem to get
started. I want to create a query that allows me to enter the Name and
despription in one table by typing it by hand when asked to.

It should add the counter automatically and then it should create
related posts referring to that ID in the related tables and ask me to
enter the values for those.

The tiong is I can't even get started on adding to the main table... I
tried typeing [xxx] in the condition field but when i ran the question
it automatically wanted to enter 140 posts without asking me what to
enter so that can't be the way.

/Maria
Click to expand...
Click to expand...
 
D

Duane Hookom

Is there a reason you can't just display the Huvudtabell in your main form
and use subforms for PFD-er and Biloriginal? If that isn't reasonable, you
could use code in your form's After Insert event to append records to the
related tables.

I'm not sure what you mean by "asks me...". You could follow the append
queries with MsgBox() prompts and opening editing forms.

--
Duane Hookom
MS Access MVP

Maria said:
It's all in swedish so I'm not sure if it helps but here are som of my
table and field names.

Table: Huvudtabell
Fields: ID
Namn
Syfte

Table: PDF-er
Fields: ID
PDF
InDesign

Table: Bildoriginal
Fields: ID
Bildfil

ID is the field were they all relate and Huvudtabell is the main table
containg the primary key.

What I wanna do is that when I add a field to Huvudtabell Access ads a
field with a matching ID to the other tables and asks me if I wanna
fill in the file names.






Duane Hookom skrev:
Do you have some table and field names you could share with us? Also, try
to
explain better the functionality you are hoping to achieve.

--
Duane Hookom
MS Access MVP

Maria said:
This seems like such a simple thing to do but I just can't seem to get
started. I want to create a query that allows me to enter the Name and
despription in one table by typing it by hand when asked to.

It should add the counter automatically and then it should create
related posts referring to that ID in the related tables and ask me to
enter the values for those.

The tiong is I can't even get started on adding to the main table... I
tried typeing [xxx] in the condition field but when i ran the question
it automatically wanted to enter 140 posts without asking me what to
enter so that can't be the way.

/Maria
Click to expand...
Click to expand...
Click to expand...
 
Top