Search results

-you're right for the aircraft. There's no need to have it twice. -"You have the linking field properties set to ICAO instead of AirportID." Where did you see that? -ok

Hi All, I've got a problem with my database and I don't know how, why it occured and how to solve the problem. I've attached the database so you can have a look. I'm working on a airport database. I've been using this forum to answer a lot of my questions as i don't have any training in...

I 've managed to create the relationship between the aircraft and the tbl_Airport and tbl_Runway. To do so, I created a table tbl_Aircraft with 2 fields, AircraftID and Actype. Then, in both table (Airport and Runway) i added a field ActypeAirport and ActypeRunway using a data type 'Lookup...

Thank you for your feedback. tbl_Administrator I've decided to stop working on this table for now. What I had in mind for this table was the user table with username and password. However, I also wanted to create a setting where you can choose (when opening the database) if the user wanted to...

Thank you, it works now. I'll always keep in mind to create a ID as a primary key and autonumber. Mat

Oh! ok I get it now. Thanks

"Records are composed of fields" source : https://www.webopedia.com/TERM/R/record.html So, the record is the table? Because the table is composed of fields right? Bottom left : - In design view there's : F6=Switch panes, F1=Help - I View there's "ready". Is that what you're trying to point out?

Could you try and explain it differently please? To answer your questions. A record are the columns I create in the table? In the runway table, I have 57 columns. Each column has a unique value that depends on the runwayName (primary key) Mat

Sorry plog I don't understand what you want me to delete. I not quite sure I fully understand (well I kind of understand) "Every record on the many side has to have precisely one matching record on the parent side." All the record in the table Runway are unique for a RunwayName (primary key)...

Than you, Frothingslosh, thanks, I'll check your link and see what I can do. plog, I not quite sure to understand. The record you want me to delete is the ICAO field in the runway table? If I do that, how can I link a unique airport to multiple runway? Mat

Soory, I forgot the question : Does someone have an idea why it won't work? Is it because my tables are not correctly normalized? Is it because the propreties in each field I want to link are not the same? Thank you, Mat

Hi All, I'm having trouble creating my database (airport database). After charing my database with this forum concerning another topic, I was advised to rething the structure of my tables. I'm not 100% sure I comply with the 3 rules of normalizations. The reason I not 100% sure is because...

Also, if this is done properly (setting the tables correctly) the next step is to create the relationships (in Database tools)?

Thank you for the tip on the normalization. I have a few questions concerning the tables and the normalization. -When a field can be a combination of numbers and lettre (example : latitude in decimal). What's the best field type? short text or number? -I've attached the database for you to...

Thank you! I'll deleted my queries and my forms. I'll concentre on normalizing the tables correctly. If you have more comments, I'll be glad to hear them. It's maybe to much asking, but when I finished normalizing the tables, can I post the database here to get a feedback? Mat

Yes, sorry. Here it is.

No hard feeling on your comment. The fact I asked the question is to get a answer. And it comes from the fact I did something wrong in the first place. I'm going to rethink through my approach. I'll probably come back with more questions. I've attached my database, so you can have a look and...

Thank you for the welcome to the deep end! The project is a lot of work and no one in the office knows how Access works. For the problem I had for the convert commande. I manage to solve the problem by using Val(). For example : Me.TODA=VAL(TORA)+Val(me.CWY) For the rest, you've given me a...

Thank you. I have some questions on what you did. Concerning the convert commande : So I've tried your convert code on your form and it works. I created the commande button to convert to CWY/SWY and it works. However, when I create the commande button to convert TODA and ASDA. The code doesn't...

I've got no training at all. For the moment, I only use tutorial on the internet. I have booked a basic training session next week, but in the mean time I have to continue on the project. The previous intern has done sorting out what data has to be stored, the data the user need to see, the...