Indsætte data i underformular

I XP er det vist nemmest hvis du bruger:

"Opret en formular vha. en guide"

Yes I know, men det giver mig kun de felter der er i 'Tilmelding'.
Og det dur ikke. Id'erne skal jo joines med 'Rejse'.

Når du laver formularen kan du vælge både tabeler og forespørgsler.

Kan du ikke lave en forespørgsel der indeholder de ønskede info fra begge tabeller, og medtage denne i din underformular ?

hmm, måske.. jeg prøver lige..

if I understand your question correctly yu have a many to many relationship. If you have designed your tables correctly the you should be able to use the form wizard to make your forms.

Hvordan det?
I tabellen 'Tilmelding' der en ID til 'Kunde' og en til 'Rejse'

I formularen vil jeg gerne vise den aktuelle kundes tilmeldinger til rejser (altså vise nogle af stamoplysningerne til rejserne)

if you send the dB to eksperten@santhell.dk I will make it for you.

You can make query joining Kunde+Tilmeling and the use the query in the sub form.

I'll send it right away..

please ZIP the dB

Outlook XP will not allow .mdb files through so you will have to either ZIP it or rename it to .txt

I've send it to you..

I'll send it again..

I have received your mail with an MDE file but I can NOT open it!
You must send it again ZIPPED or renamed to .txt

OK, the MDB not the MDE

I have it :o)

I think you have sent me the wrong database :o)

Christian, take a look at the data type for RejseID in the Tilmelding table (text) and in the Rejse table (Autonumber, long int). They MUST be the same data type to make a JOIN. You must make sure your tables and relationships are correct and I am sure the wizard will work once they are.

ok, I'll try that..

If the wizard deosnt work make a query containing all the fields from Rejse and only the Kunde from tilmelding, this field is needed to join to the kunde on the main form. You can hide thsi field in the sub form!

like this:

SELECT rejsenr, sted, datofra, datotil, k.kundeid
FROM rejse, kunde AS k;

??

sorry, I'm watching a film as well :o)

No! Like this
SELECT Rejse.*, Tilmelding.kundeid
FROM Rejse INNER JOIN Tilmelding ON Rejse.Rejseid = Tilmelding.rejseid;

Use the query builder to do this. Drag both tables into the query window, if your relationships are correct then you will see a thin line joining the two field. Drag the * (all fields) from the Rejse table and the kundeID from Tilmelding.
Have you altered the data types?

now if you have made a query use the form wizard to make your forms and it SHOULD work, if not get back. I will first see it tomorrow evening though.

ok ser ud til at løsningen blev som jeg forslog

Kommentar: katborg
01/12-2002 18:22:43