473,320 Members | 1,856 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Inheritance: Automatically creating superclass table entries

2
Hi,

consider a simple hierarchy with cars and bicycles inheriting from vehicle. Every class gets it's own table with shared attributes residing in Vehicle anda 1:1 PK-relationship to the subclass tables.

I wan't to create a MS Access form for creating cars.

I created a simple form based on a query containing attributes of both Vehicle and Car.
Due to auto-numbering in Vehicle a new vehicle record is autmatically created. Of course when entering data of Car-attributes, Access complains about not finding a corresponding ID in Car.

How can I get Access to create it automatically?

Thanks!
Sep 13 '13 #1
3 2197
Rabbit
12,516 Expert Mod 8TB
Make the car a subform in a vehicle form and the subform will automatically create the record when you enter car info.
Sep 13 '13 #2
Zagen
2
Thanks for the answer, but apparently it doesn't!
Access requires a related record in Vehicle and doesn't add it on it's own.

Although I have to say, I'm not that familiar with Access. I infer most of it from my general database knowledge.

I tested with two basic forms based on related tables. Is there something else I have to configure?
Sep 16 '13 #3
zmbd
5,501 Expert Mod 4TB
please post the sql for the query that you are using for the form
Please rememeber to format the SQL text by selecting it and then clicing on the [CODE/] format button.
Sep 16 '13 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Galina | last post by:
Hello I am trying to create a table, which includes a field type LONG. The wizard hasn't allowed me to enter storage settings for this table. It set the initial size is 64K and not available to...
35
by: .:mmac:. | last post by:
I have a bunch of files (Playlist files for media player) and I am trying to create an automatically generated web page that includes the last 20 or 30 of these files. The files are created every...
5
by: Sami | last post by:
Please bear with me, and if you answer this question, please do it step by step. I am new at Access, not at all sophisticated. I am using Office XP. This will need to be read in Access for...
2
by: Phil Longworth | last post by:
Im very new to Access 97 and Im sure I should be able to do this but cant work out how. Im bulding a database for my stamp collection. I have two tables; one with details of all the individual...
3
by: Priya | last post by:
Hi, I need to create a temp table in my asp.net web services program. I have an xml file of the format <uom_masters> <uom_code>varchar</uom_code> <uom_description>varchar</uom_description>...
11
by: Sheau Wei | last post by:
i wish to know how to create a dinamically edit table entries .can u help me ?thanks.
5
by: KewlToyZ | last post by:
Good day, I am stuck in a strange situation. SQL 2000 Server, creating a stored procedure to use in Crystal Reports 11. I am trying to build a report without creating a table or temprorary table in...
0
by: dreaken667 | last post by:
I currently have a PHP script that pulls records from a table and runs PHP scripts based on the table entries, but it requires that I actually load the page in a browser and wait for it to complete....
1
by: replica watch | last post by:
I am creating a table cell by cell (create the table, add columns, create row, add cells to the row) in which I want to add the capability for users to sort ASC and DESC by column header. Can...
4
by: monion | last post by:
I am having a heck of a time creating a table with more than 140 or so columns when using php into mysql. Any known issues after a certain #? Thanks,
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.