Hi
Its a question regarding creating and linking tables. I am using FileMaker Pro to implement it, but probably someone can help me here with the tables and fields making ?
I have following tables and fields:
Invoice: invoiceNo, company, total, paid, balance.
item : invoiceNo, itemName, quantity, price
Please advice if the categorization is correct or wrong?
I have made invoiceNo as primary key in each table and i have linked these tables with this key.
I have created a form and added Edit boxes with these fields on it. The problem is that i am able to write on only fields which are in table 'Invoice' - but i cant write on fields that are in table 'item'.
Where have i gone wrong.
Please help
thanks
Qi
1 1135
Hi
Its a question regarding creating and linking tables. I am using FileMaker Pro to implement it, but probably someone can help me here with the tables and fields making ?
I have following tables and fields:
Invoice: invoiceNo, company, total, paid, balance.
item : invoiceNo, itemName, quantity, price
Please advice if the categorization is correct or wrong?
I have made invoiceNo as primary key in each table and i have linked these tables with this key.
I have created a form and added Edit boxes with these fields on it. The problem is that i am able to write on only fields which are in table 'Invoice' - but i cant write on fields that are in table 'item'.
Where have i gone wrong.
Please help
thanks
Qi
As you said, you have made invoiceno as primary key in both the tables, you should have made invoiceno as foreign key in item table and not primary key. This should be your first change.
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Marco Simone |
last post by:
Hi,
I have 4 tables, tblCompany, tblA, tblB and tblC.
tblA, tblB and tblC contain same type of data, they should be in one table,
but since there are many fields, I split it into 3 tables.
Each...
|
by: Megan |
last post by:
Hi everybody-
I'm helping a friend with a music database. She has an old one and is
creating a new one. She wants to compare records and fields in the old
database with records and fields in the...
|
by: Michael Deathya |
last post by:
Hi,
I am pulling over 400 different metrics from an Excel spreadsheet into
Access (97). Conceptually, each row represents a single set of these
400 metrics. However, because of the 255 column...
|
by: svdh |
last post by:
I have posed a question last saturday and have advanced alot in the
meantime. But I am still not there
Problem is that I try to merging various fields from various tables in
one document in Word...
|
by: dskillingstad |
last post by:
I've been struggling with this problem for some time and have tried
multiple solutions with no luck.
Let me start with, I'm a novice at Access and I'm not looking for
someones help to design my...
|
by: Adam Turner via AccessMonster.com |
last post by:
If I had a field called "Name" in an Access table "Contact Info", and the
field contained VBScript...
Function Main(rstFields)
Main = rstFields.Item("FirstName").Value
End Function
1. How do...
|
by: Reader |
last post by:
Hello all,
I am joining two tables in a query and the output should be all those
records where two fields in table1 match two corresponding fields in
table2.
I joined the tables using both...
|
by: Monkey Boy |
last post by:
I've used Access pretty basically for the last couple of years, and I'm
slowly trying to get a bit more advanced.
I'm attempting to consolidate multiple tables with similar information.
Some...
|
by: aljamala |
last post by:
Hi,
I have a group of 5 tables laid out of the web page. 2 go on the left
side and 3 on the right. These tables retrieve data from the database
so the number of records (rows) returned varies....
|
by: farouqdin |
last post by:
Hi all i have code which loops through table and deletes the duplicate
records. This code does it for one table. How do i change it so it
goes through several tables?
On Error Resume Next
Dim...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
| |