Search results

I did as you suggested and consolidated the Memo_Table with the Locus_Card_Table and with the Wall_Card_Table, so there is no one-to-one relationship. It seems to have fixed the problems with the Locus_Card form and Wall_Card form, but we will try working with it in real-time tomorrow at the...

OK, I'm trying to send it zipped. Hope I did it right. I just noticed that there is a similar or a bit different issue with the form that we used to enter data into these records that are defined as walls. I'm not exactly a programmer (far from it) so there are a lot of tables, queries and...

Hi Sneuberg and thanks for the fast response! Here is the SQL of the query that is used as source for the relevant form: SELECT Main_Locus_Wall_Strata_Table.AREA, LOCUS_CARD_TABLE.LOCUS, LOCUS_CARD_TABLE.DEFINITION, Main_Locus_Wall_Strata_Table.Stratum, Main_Locus_Wall_Strata_Table.UNIT...

Dear Access experts! We are trying to upgrade and update an old database of our archaeological excavation. We are using access 2013, although the database originally was designed more than 10 years ago. There are three main tables that we use: Main_Locus_Str_Table Locus (number, PK) Type of...

OH WOW!! Thank you guys, this gives me a lot to work on! Its amazing how experienced designers can point these flaws so clearly, while I can stare at the screen for hours and never figure it out. A lot to learn.... I'll get to work, and let you know how its going. Will probably take me a few...

Thanx for the replies guys, I really appreciate your help! So, for example, if the OBJECT_MEASURMENTS table has the following fields: ObjectID [relating to ObjectID in the OBJECT_BASIC_DATA table] Width, Thickness, Length, Diameter, CompWidth, CompThickness, CompLength, DrillDepth...

I've started working on a database some weeks ago, and some of it works great, yet some doesn't... The database is meant to gather data on archaeological objects from excavations - specifically objects made of bone, antler, horn etc. It already has a lot of tables... maybe too many? :confused...

Hi everyone, My name is Ariel, I'm from Jerusalem, Israel. I'm an Archaeologist and I'm trying to build a database related to one of my projects. I think I'm over my head in tables... I'm new to access, but I read a lot, and I'm struggling with it :banghead: I hope to find some help here!