Stel uw vraag

rymong's profiel - activiteit

2017-12-11 12:14:38 +0200 badge ontvangen  Beroemde vraag (bron)
2017-03-30 07:49:18 +0200 badge ontvangen  Student (bron)
2017-03-29 16:43:19 +0200 badge ontvangen  Opvallende Vraag (bron)
2017-03-28 23:28:39 +0200 badge ontvangen  Populaire Vraag (bron)
2017-03-28 18:37:27 +0200 reageerde op een antwoord Form in Base: want fields to effect each other

I asked here: https://ask.libreoffice.org/en/questi...

Thanks for responding so quickly!

2017-03-28 18:36:49 +0200 stelde een vraag Creating relationships in Base

Ucanal Database v023-119.odb

Hello.

I am trying to tie the different tables in an archaeological database together using Relationships, but I keep getting an error when I try to create one. Can you assist?

An example: "Name" column in ANCIENTITEM to "Lot" Column in Lot Table This would tie our information for each lot to the ceramics found in that lot.

Error: Column types do not match in statement [ALTER TABLE "Lot Table" ADD FOREIGN KEY ("Lot") REFERENCES "ANCIENTITEM" ("NAME")]

Forgive me, I'm not knowledgeable about relationships, keys, etc.

2017-03-28 17:11:10 +0200 badge ontvangen  Leerling (bron)
2017-03-28 16:11:11 +0200 reageerde op een antwoord Form in Base: want fields to effect each other

Ratslinger, not sure if you will see this. You helped me a great deal with my database last summer. I'm having a new issue, and I was wondering if you could help. I am trying to tie the different tables in the database together using Relationships, but I keep getting an error when I try to create one. Can you assist?

Error: Column types do not match in statement [ALTER TABLE "Lot Table" ADD FOREIGN KEY ("Lot") REFERENCES "ANCIENTITEM" ("NAME")]

2016-07-26 01:53:35 +0200 badge ontvangen  enthousiast
2016-07-25 19:41:59 +0200 reageerde op een antwoord Form in Base: want fields to effect each other

Ratslinger,

This looks absolutely perfect! Thank you so much. What is the best way to bring over the form, tables, and macros that you created to the database I have already set up?

Thank you again.

2016-07-18 08:29:13 +0200 badge ontvangen  Beroemde vraag (bron)
2016-07-13 23:28:23 +0200 reageerde op een antwoord Form in Base: want fields to effect each other

see above and thank you!

2016-07-13 22:13:49 +0200 beantwoorde een vraag Form in Base: want fields to effect each other

Thank you. I don't have enough Karma to upload the database file with this message. Here is a link to it:

https://www.dropbox.com/s/0zasml0cvhs...

Within the "Variety Form" I would like the fields Ware, Grupo, Tipo, and Varidad to autofill from the table "Ceramic Wares" when a specific WGTV# is entered.

For example, if I enter 01010201 in the WGTV# field, I'd like the "Ware" field to automatically fill "Uaxactun Sin Engobe"

and have the "Grupo" field fill in "Achiotes", and the "Tipo" field fill in "Baldizon Impreso", and the "Varidad" fill in "Mono."

2016-07-13 21:43:52 +0200 badge ontvangen  Opvallende Vraag (bron)
2016-07-13 17:52:57 +0200 badge ontvangen  Populaire Vraag (bron)
2016-07-12 21:40:53 +0200 stelde een vraag Form in Base: want fields to effect each other

I'm in archaeologist trying to develop a form of ceramic analysis. An ancient Maya ceramic vessel is attributed to:

A Ware, of which there are dozens

A Group, of which there are also dozens but limited by the Ware.

A Type, of which there are hundreds but limited by the Group.

A Variety, of which there are thousands but limited by the Type.

So, I would like to have fields in the form for Ware, Group, Type, and Variety where the options available for each successive field are determined by what has been put in the prior field.

Also, since there are so many options for each of these fields, drop down menus seem like they would be unwieldy (e.g. selecting your type from about 300 options). So, we are thinking of using code numbers, where once a code for a Ware is input, another field auto-populates with its name.

Apologies if this is asking too much or unclear.