1 To Many Relation, 1-site Is Not Yet Created

Apr 11, 2006

The problem:
I have a table: TBL_INVOICES
and I have table TBL_SHIPMENT_NOTES
One invoice can have many shipment notes, so a created a
One to many relation between TBL_INVOICES and TBL_SHIPMENT_NOTES

However, the shipment notes are created earlier, thus there is no
invoice_ID when I create a shipment note.

How to deal with this problem ? Please, help ...

View Replies


ADVERTISEMENT

New To Site Need Some Help

Jul 25, 2005

I Work For a school district and have been assigned the project of creating a Campus Improvement Plan Strictly using an access back end. I'm having some trouble sorting my data I designed the Report exactly how it has to look but I cannot get more than one entry per form on the report. So i was wondering if anyone knew a quick fix for appending to the report. Thank you

View 2 Replies View Related

Untrusted Site

Nov 25, 2007

I am working on a laptop computer running MS Access version 2002. I'm trying to access a data file located on my desktop computer via my wireless network. (Same version of Access).

I can see the file without any problems, but when I try to open it I just get the following error message:

this file is located outside your Intranet or on an untrusted site. Microsoft Access cannot open this file.

Both computers are running under Windows XP. O/S: MS Windows 5.1 service pack 2

How do I resolve this?

View 3 Replies View Related

Web Site And Access

Aug 20, 2004

I want to build a web site that people can access over the internet. I want the user to have the ability to run one of my Microsoft Access databases just as they would if the database was loaded on there PC. Is Microsoft Frontpage the answer or do you have any other recommendations of a web building software package?

THANK YOU IN ADVANCE - jOHN

View 1 Replies View Related

To Untwist A Site Traffic!

Nov 22, 2006

Наверняка ниже должна быть масса профессиональных терминов: про регистрацию в каталогах, поисковую оптимизацию, релевантность запросов, целевую аудиторию, продвижение бизнеса в сети, результаты поиска, исследования поисковых систем...

По идее текст должен содержать: Узнаваемость сайта, стратегии интернет маркетинга, контекстная интернет реклама и пр.

Документов должно быть много. Статьи по темам, помощь в раскрутке, советы профессионалов и прочее, что может быть полезно начинающему веб-мастеру самому освоить "науку раскрутки" (а фигли, мы ж не жадные ;) ). Обязательно по всему тексту должны быть расставлены ссылки на самых "вкусных" словах:

Регистрация сайта в поисковиках и каталогах

Уверен, будет текст, призванный окончательно убедить клиента сразу оплатить услугу и получить гору клиентов. Примерно такой: Мы обладаем огромным опытом в оптимизации сайтов, ведьу нас работают только признанные специалисты интернет маркетинга и рекламы. Используйте опыт специалистов в области оптимизации сайтов, знающих свое дело.

Ну вот примерно так. Представили? А теперь к делу!
оптимизация сайта (http://www.mulka.ru)
раскрутка сайта (http://www.mulka.ru)
раскрутка сайта (http://www.mulka.ru)
оптимизация сайта (http://www.mulka.ru)
оптимизация (http://www.mulka.ru)
интернет реклама (http://www.mulka.ru)
создание сайтов (http://www.mulka.ru)
создание сайтов (http://www.mulka.ru)
раскрутка сайта (http://www.mulka.ru)
раскрутка (http://www.mulka.ru)
поисковое продвижение (http://www.mulka.ru)

View 4 Replies View Related

Site Map Table Design Help

Sep 22, 2006

If you're building a database to represent a web site architecture, what's a good way to design the tables?

Would you make a table for parent sections, and then another table for the first child of those sections, and then another table for children of that child and so on? Sounds clumsy to me. What happens if a parent section can be drilled down into 15 pages deep? You'd need 16 tables.

What I'm doing is building a test plan manager for a site that has varying levels of depth in each parent category and I'm trying to decide how to develop the input/browse form.

View 1 Replies View Related

How Can I Publish A Database On My Web Site?

Nov 1, 2006

Hi!

I need help!!!

I have made a books-database in MS access. I want to publish it on my web site. It should be possible for the visitor that search different books on my database.
I am able to write HTML code (using MS FrontPage) but how make a search form and how would the HTML contact my database (book.mdb) on my web-server?
I have find some HTML code.. for search-form but here it is used kbook.asp what I don’t understand it . I have tried to replace kbook.asp with book.mdb, but it does not working.
I have heard that there are some software that you can easily publish your database on your homesite but which software???


Kind regards, sofi



Code:<HTML dir=rtl><HEAD><TITLE>K</TITLE><META content="text/html; charset=windows-1256" http-equiv=Content-Type><LINK href="kformat.css" rel=STYLESHEET type=text/css><META content="Microsoft FrontPage 5.0" name=GENERATOR></HEAD><base target=kDown ><BODY bgColor=#EDF2EC text=#000000><FORM action=kbook.asp method=post name=SEARCH><TABLE align=center bgColor=BDCEB9 width=420><TBODY><TR><TD width=120>Choose</TD><TD width=220><SELECT name=Kids><OPTION selected value=DIV>Kids<OPTION value=CHD>History</OPTION><OPTION value=CIN>Animales</OPTION></SELECT> </TD><TD align=right width=80><INPUT type=submit value=Show></TD></TR></TBODY></TABLE></FORM></BODY></HTML>

View 2 Replies View Related

Relation

Jun 23, 2007

I'm using the new Access. I never created a relationship till now. I linked three databases. I expected to enable a right-click and launch and be able to see all the records in the linked databases. Nothing happened. What am I doing wrong.

Bob

PS Is there a way to review the code used to creat relationship. I'm from dBase 4 where we had a dot prompt or regedit, not graphics. Not a complaint. It might taker me abit.

View 4 Replies View Related

To Relation Or Not To

Apr 14, 2005

Im wondering, i have goten pretty comfortable with vba and undbound projects. Now im facing a pretty big project, and it got me thinking should i even bother with relationshops and alll that other stuff you need when making bound forms. i figure all the relationships can be codded in vba.

Let me know on your opinion

View 1 Replies View Related

Connecting Remote Site (setup Help)

Mar 5, 2008

I just found out that this years project wil be setting up a remote office location. There will be about 5 users at this location. They want complete control over all equipment. What they have in place here is Terminal Services and thin clients.

Our db is Access front end with SQL backend.

My initial thought for the remote office is:
High Speed Internet
Either CAT5 to each desk or Wireless Access Point
5 thin clients.

Using RDP they should have no problem accessing our network unless they can't all use the same public IP address for our main office.

The other thought is Setting up a Point-to-point VPN. My biggest problem is I havn't worked with thin clients until I started working here. I don't know what I would need at the remote end in order to connect the thin clients through the VPN. They don't want any servers or desktops if we can help it.

Does any one have any suggestion or thoughts on this?

Thanks,
Dan

View 2 Replies View Related

Using Two Dates To Determine If Someones On Site...

May 3, 2007

Hi,

I need a little help with my Query design.

I have an Arrival Date and a Departure Date for campers checking in on a campsite. I need to produce a report for the warden to have to check who's on site.

So far, the best way I though was using a new field in the query for "On Site" (which isnt in the control table) and then using an expression such as...

[Date of Departure] < Date()

However this isnt working, probably for some silly oversight on my behalf.

Any help?

Thanks, Adzi.

View 2 Replies View Related

How To Add A Site Or Publisher To Trusted List

Oct 22, 2011

In 2007 how do you add a site or publisher to your trusted list.

View 1 Replies View Related

Help With Relation Database.

Aug 8, 2005

Im trying to make a computer invoice and quotation system, and im not having much luck. I have 2 table, one called products which has my product details (eg, product_code = cpu_amd_athlon64_3500) and a stock table, which uses that product code to call up all the other details. I want to go to my stock table, enter in my product code, and it brings over the product description and price from the products table. Ive been fiddling with relational databases and forms but i cant get it. Any help is much appreciated!

Subaru

View 3 Replies View Related

Relation Between Tables?

Jun 6, 2005

Hi everyone,
I cannot figure out how to link my tables. Here is my problem: I have one main table that contain informations about contracts (No folder, name of the provider, etc.) And I have 12 other tables. Each of them contains informations about one specific type of invoice. for exemple, one table is used for gaz billing, an other one is used for shipping, and so on. Now I don't know how to link all these tables with my main one. Because one entry in the main table have a 1-to-many relationship with all these tables. should I leave the relations, and just retreive information manually?

Here is the definition of the main table:
No - AutoNumber and primary key
Localisation - Text
...

The definition of the 12 tables is:
NoBill - AutoNumber and primary key
NoAutoInstallation - that contains the No from the main table
Total - total of the bill

I'm really confuse. Thanks in advance for your help!

View 1 Replies View Related

One Table Relation To Two

Feb 4, 2008

Usually, a lookup column looks like this - "Take the value stored in this lookup column, use it to find some information in another table, and then display the information from that table in this table."

I need to Take the value stored in this lookup table, use it to fill two separate tables depending on ordertype. If the order is type1 I fill table 2 if order is type 2 I fill table 3


I have a database with 3 tables:

Table 1:

ID autonumber primary key
ORDR (numeric value increases by 1)

Table 2: Oders printable info1

ID autonumber primary key
ORDR (linked to Table 1 )

Table 3: Oders printable info2

ID autonumber primary key
ORDR (linked to Table 1 )



It's a piece of a large dabase and hard to explain, but I have to enter specifinc information in Table 1 then with relationship enter that information in Table 2 or Table 3 depending on the order type. Table 2 and 3 hold other information that is used to generate a report. Table 1 provides start unique identifier increased by 1 like, ORDR-001, 002 003 etc.

I never have to enter or should I say link same order number from table1 to both. Would like to prevent it by acident too.

Do I need a junction table to make it work? Is there a better way to make it work?
Thanks.

View 4 Replies View Related

VBA Access To Gather Info From External Site

Dec 29, 2006

Hello All

I am doing an assignment, which is fantasy football database and instead of entering the data i thought could i import the data from say another site which is updated regularly. Can it be done with VBA Access also wanted to link the database to a apache server. Any pointers on how to do this would be appreciated or if it is feasable. Have to have assignment in before Aprial.

John

View 1 Replies View Related

Looking For Good Tutorial On Feeding A Site With A Database.

Oct 25, 2004

I am very new to ASP and Access. I need to learn how to create a database full of images and text to feed dozens of webpages for a new site I am doing. I have googled many times and can't really find what I am looking for. I've come across ADO several times. Is this similar to what I am looking for? Thanks.

View 5 Replies View Related

Modules & VBA :: Get XML From A Site And Import Data To Access

Dec 4, 2014

I get XML's from a site and want to import the data to Access. If I use the native import then I get multiple tables and the data is a little jumbled. For instance: I get 1 table with track names and a different table for track numbers with no way to relate the to accurately. I would like to be able to parse out the XML and have it update my table as it goes so I have less "junk" in my DB. I just can't figure out how to call out the XML tag and tell it to copy that info to the correct field.

View 1 Replies View Related

[Table Relation] Problem

Nov 9, 2005

Hi!

I'm new to MS Access databases.

I'm trying to buil a database of a kind of elements. Every element has it's description (name, number, etc), but there are other parameters, which I want to add. I'll try to picture this:

Element_Table--
|
- Date
- Number

Element_Additional_Info--
|
- Data1
- Data2

For every element in Element_Table I want a seperate table Element_Additional_Info.

I tried to do this with relations, but for every element I have the same data in addition info.

Can anyone help me??

Thanks in advance...

--
Best regards
fahur

View 3 Replies View Related

A Problem With A Relation Table

Apr 18, 2007

I've been stuck on this for hours. I have to create a relational database on a small company and when i try to create a query on anything i only get one record showing up, with no criteria. This is my relationship
http://img156.imageshack.us/img156/1809/relationshipsbi0.png (http://imageshack.us)
Any help would to make this relationship work would be greatly appreciated, i need to go ly down

View 3 Replies View Related

Problem With Table Relation

Jun 11, 2007

I'm pretty new on access but I need to get a project done for my office which is a call center, we are trying to identify and quantify the reason our agents are calling our support desk, and I'm trying to set up a simple database that our support agents will feed up.
I have a table (A) that contains AGENTNAME, AGENTID and SUPERVISOR (every agent is assigned to a supervisor and there are four supervisors and around 60 agents) the primary key on this table is autonumber. I have another table (B) that is a lookup table and contains the reason CODES (Ex, GRAL INFO, RATE, ETC), there is another table (C) that is filled up using a form that pulls agents name from table A using a combobox, also pulls the reason codes from table B and fills date and time also. the problem is when I try to set up a report using all this data, I cannot get the SUPERVISOR name and AGENTID on such report, I think this may be related to the tables relationship and Iґve tried several options but cannot work it out.
Can you please help, any help from your vast knowledge will be greatly appreciated. Thanks in Advance

View 1 Replies View Related

Index And Query Relation?

Jul 4, 2007

Hi guys

thank you in advance for any idea/info!!

i have 2 tables, P.O and Invoice. In PO tbl i have an Invoice field with Index set to Yes (No duplicate)
On a form based on PO table, I couldnt enter a new record due to this so i set the Index back to NO
Now..I have a combo bound to PO table with a query taking a list serial number from another table. I want to filter away whatever serial numbers from this list that have been added to PO so i write this SQL
"SELECT DISTINCTROW tblComputer_Cabinet.[CC_Serial #]
FROM tblComputer_Cabinet, tblPO
WHERE (((tblComputer_Cabinet.[CC_Serial #])<>[tblPO].[CC_Serial #]))
ORDER BY tblComputer_Cabinet.[CC_Serial #];"
which worked fine before i removed the index

Why was it?

View 2 Replies View Related

Creating A Simple Relation

Dec 17, 2007

I have basically a list containing 400 names and addresses. For each address, an event can occur. If and when it does, I add 3 fields to hold the date, type, and result of the event.

Simple enough, but I am at a complete loss as to how to make a simple rdb with table 1 containing 400 rows of address data and table 2 containing event data. Hopefully somebody can help me.

My table in Access 2000 in its simplest form consists of the following fields:

ID (primary key)
Address (actually several fields)
Date1
Event1
Result1
Date2
Event2
Result2
|
|
DateN
EventN
ResultN

View 10 Replies View Related

Queries :: Table Set Up In Many To Many Relation With Each Other

Mar 14, 2014

i have a table set up in a many to many relation with each other.

it is
tblProducts
productId PK
productcode
Description
Status

tblLink
ProductId PFk
Location PFk

tblLocation
LocationID PK
Location
QuantityIn
DateIn
PONumber

I have created a query that shows me the product by location and a query to show me locations with product...What i am trying to do is have a main for that show me the product and insert a list box(Form Control) that show me the locations and the quantity for that product. the problem i am having is that i cant get the query to only show me the results for the product on the main form it shows me all the products on all the locations on the list box.

View 3 Replies View Related

Tables :: Many Relation Between Two Table

Sep 1, 2014

i have 2 tables

1. Actors Table
2. Movies Table

i create a third table so i put manually the id of an actor than the id of the movie belong to this actor.so in the third table we could see the movie more than one time because there are many actor in the same movie..could i get the result in the third table or anything but with an easier method because it takes too much time to finish it i have more than 1000 film.

View 4 Replies View Related

Deleting Records That Have No Relation

Aug 9, 2011

I have two tables, one for jobs and one for clients. I have a one-to-many relationship, so one client can have many jobs. Due to a problem with data entry, I have some client records that have no job associated with them. I need to delete these records.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved