473,320 Members | 1,979 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.

How do I unjoin two tables in a form that I created?

1
Greetings--

I am using a form with tabs. There are two tables that are linked and when you click and drag the field to the form, it asked the join property. I think (I know) that I selected a the wrong one. However, how do I undo it?

Thanks
Apr 5 '13 #1
1 1266
TheSmileyCoder
2,322 Expert Mod 2GB
Open the main form in design view. Then select the CONTROL which contains the subform (so not the subform itself). Now look at the properties "Link Master Fields" and "Link Child Fields".

To clear the relationship simply clear both fields. To add a new link, click the ... to the right of the property after clearing it.
Apr 5 '13 #2

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

Similar topics

3
by: A Future Computer Scientist | last post by:
I've gone through the newsgroups and I don't think I found the answer to my question. My question does anyone know the coding to show a form at runtime if it's not the first form created, since...
19
by: Bruce Duncan | last post by:
I know this isn't a php group but I was wondering if my problem is with my javascript in my php code. I'm debugging someone else's code and I can't figure out why this form won't submit. This...
1
by: narayana | last post by:
how to know about how many tables i created in that database.if the database is connected to many users. i want the query in this way that i want creater,number of tables,time,updates . the...
1
by: RLN | last post by:
Re: Access 2000 I have a form (Form1) where the default view in the properties is set to "Datasheet". When I click on the Form1 object from the container to display it, it displays fine in...
4
by: John | last post by:
Hi I am getting my form using; frm = New frmMyForm. How can I check if this statement has been executed? I have tried If frm Is Nothing Then, but it does not work. Thanks Regards
0
by: amr | last post by:
if i create some tables and insert into them some data then oracle installation is dropped or windows insallation is dropped ,how to get this tables and their values again
7
by: Pieter | last post by:
Hi, I have some generic module that handles exceptions. simply you call it like this: "LogManager.ErrorMessage(ex)". Worked great, until we now discovered that it isn't Thread-safe. What...
0
by: magickarle | last post by:
Hi to all. Little introduction on what I'm trying to do: I'm in charge of creating an access database for our supervisor where they can grade their agents. Per ex: agents are talking to customers...
1
by: =?Utf-8?B?c2ltb25j?= | last post by:
I want to rewrite a macro created in Excel VBA using VB.net. I created a fairly elaborate form in VBA and want to know if there is an easy way of importing it into VB.net without manually creating...
1
by: visweswaran2830 | last post by:
How do database and tables get created when I am pressing create user wizard in asp.net?
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...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
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...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
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: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

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.