I dette særtema ser vi på, hvordan cloud og AI bliver fundamentet for virksomhedernes digitale forretning, og hvordan de nye muligheder for automatisering og forretningsværdi kan udnyttes uden at miste overblik, sikkerhed og menneskelig kontrol.
yxos>I think you need to alter your tables slightly!
KontoIbrug ---------- KontoID (autonumber) Konto text
Then change Konto in the Konto table to a long integer. You can do this by using the lookup wizard in the Data type list. This will create a relationship between you tabels. If you now make a form using the form wizard you will automatically get a combo which takes the value from KontoIbrug and puts it in Konto!
Thanks for your suggestion Terry, but it didn't work out as you said. There is already a one-to-one relation defined between those two tables. This is how it should be I believe. Problem is that the combo is based on table Konto; not table KontoIbrug. Therefore I can browse the accounts (konti) from table Konto, selecting any account I want but it will never be moved into KontoIbrug!Konto. Would it be possible for you maybe to send a small sample to me that illustrates? Two tables; one form; one combo. (Access 2000) yxos@hotmail.com
I don’t fully understand what it is you are trying to do so it isn’t easy to make suggestions to a possible solution.
Normally I would use an autonumber as the primary key, not a text field. Why do you need a 1:1 relationship? You could have a yes/no field in table Konto which gets set to TRUE (yes) for the konto which is in use. The other two konto are obviously set to FALSE (no).
The reason why you are having problems with this is because the primary key in table kontoibrug (field = konto) can’t be changed! So I have added a new primary key (autonumber) and then changed the konto field which is actually the foreign key to a unique index so that it is not possible to create more than one with the same value.
This is a solution but I must admit I don’t see the point!
Yes I suggested a Yes/no field, but as I wabt sure what you were looking for I tried keeping to the same idea as you were using yourself. But what is important is that you found a solution which works for you :o)
and thanks!
Synes godt om
Ny brugerNybegynder
Din løsning...
Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.
