473,324 Members | 2,193 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,324 software developers and data experts.

Use best data

Hi,
I am trying to get supplier data into a new database. I have a table containing item no connected with supplier no's. Then I have another table containing supplier no and a number of fields with address, phone, name and such data. A third table has most of the suppliers but not all of them. On the other hand this table has been updated continuously. I want to create a table with the most detailed and recent address to all suppliers of items in the first table.

KSPRODOS.............KSPROD..................SUPPR CS
itemno......................suppno................ .....suppno
suppno.....................address................ ....address
...............................phone.............. .........phone


-If there is a number in KSPRODOS/suppno it should appear in the resulting table.

-If there is a record with matching suppno in KSPROD/address and KSPROD/phone it should be used.

-If there is a record with matching suppno in SUPPRCS/address and SUPPRCS/phone it should overwrite previous data.

I want a table with all items that have a supplier number. If there is a name and address in the matching fields it should be the most recent otherwise it should be empty. Somebody will have to try to find the supplier from other sources.
Oct 24 '08 #1
1 1224
NeoPa
32,556 Expert Mod 16PB
We don't do the task for you, and we expect you to tell us where you got stuck in your own attempts at solving your problem.

However, I will jot down a basic outline to get you started. If you have any problems putting this in place then post precise details of where you are having trouble and we can help further.
  • Start with a blank table.
  • Use APPEND queries to add the data from the other tables. Make sure you add the highest priority tables first as (if the resultant table is set up properly with a unique index on [SuppNo]) any attempts to add records where an existing one exists will fail.
  • When all records from the other tables have been added in, run UPDATE queries on all the data where the required fields are Null (no data), to change them to the values you want from the tables that have the data.
If you are methodical and organised there should be little here to cause you problems.
Oct 24 '08 #2

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

Similar topics

5
by: great_googley_moogley | last post by:
Greetings, I am in the process of installing a SQL database at a customer location. I have determined that there are 3 ways to do this, and I wanted to know which is the best of the 3. 1...
5
by: Andrew S. Giles | last post by:
I thought I would post here, as I am sure someone, somewhere has run into this problem, and might have a good solution for me. I am writing an applicaiton in C# that will accept data and then put...
1
by: AMeador | last post by:
I am doing a project where we need to read a write data to a database (SQL Server 2K in this case). I have seen the use of data binding to link a property of a control to a field in a record set...
8
by: Art | last post by:
Hi folks, I'm writing a traditional desktop app using VB.NET and am stumbling over what seems like a very basic question: My app does not need to be connected to a server or another computer....
4
by: Collin Peters | last post by:
I have searched the Internet... but haven't found much relating to this. I am wondering on what the best practices are for migrating a developmemnt database to a release database. Here is the...
2
by: Anil Pundhir | last post by:
What is the best way to pass data to a web service. The client(to send data) has .net environment and also the server on which the web service is hosted also has the .net environment. Should I...
7
by: Frank Millman | last post by:
Hi all Assume a 2-dimensional list called 'table' - conceptually think of it as rows and columns. Assume I want to create a temporary copy of a row called 'row', allowing me to modify the...
20
by: Joe | last post by:
Is any one charting packing considered to be the "best"? We've used ChartFX but wasn't too happy about the way data had to be populated along with some other issues which slip my mind right now and...
3
by: at_the_gonq | last post by:
Hello, I am hoping to get some guidance on the following scenerio: I have a password protected site where users have various permissions. Are sessions the best way of storing the user's id? ...
4
by: trullock | last post by:
Hi, Can anyone suggest the best way to go about the following... I'm tracking clicks (mouse down x,y coordinates) on a web page by using some javascript to create an XHR which sends the...
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
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: 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...
1
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...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
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
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.